<select id="importOrders" parameterType="java.util.HashMap" >
INSERT INTO 表名(
name,
class
)
select
d.name,
p.class
from tableA d ,tableB p
where d.pid = p.classid
</select>
<select id="importOrders" parameterType="java.util.HashMap" >
INSERT INTO 表名(
name,
class
)
select
d.name,
p.class
from tableA d ,tableB p
where d.pid = p.classid
</select>
本文标题：SQL- Mybatis插入SElECT的字段
本文链接：https://www.haomeiwen.com/subject/zjifdttx.html
网友评论