mybitis SQL insert into 多条数据

：推荐

<insert id="insertList" parameterType="List" >
  

insert into tableName(ID, RMID, OPERATEID,        VCHAR1, VCHAR2, VCHAR3,        VCHAR4) <foreach item="item" index="index" collection="List" separator="union all">
       select #{item.id,jdbcType=VARCHAR}, #{item.rmid,jdbcType=VARCHAR}, #{item.operateid,jdbcType=VARCHAR},
      #{item.vchar1,jdbcType=VARCHAR}, #{item.vchar2,jdbcType=VARCHAR}, #{item.vchar3,jdbcType=VARCHAR},
      #{item.vchar4,jdbcType=VARCHAR} from dual
      </foreach>

</insert>

通过查询出来的多条数据

insert into tableName (ID, RMID, OPERATEID,        VCHAR1, VCHAR2, VCHAR3,        VCHAR4) select * from table2

注意字段对应