insert into 表名(字段1,字段2)
select '一','二' from dual
union all
select '三','四' from dual
union all
select '五','六' from dual
union all
select '七','八' from dual
union all
select '九','十' from dual
mybatis 配置
- <insert id="test" parameterType="list">
- insert into test(id,name)
- <foreach collection="list" separator="union all" index="index" item="obj">
- select #{obj.id},#{obj.name} from dual
- </foreach>
- </insert>