mybaties 批量导入mysql和oracl区别

mysql 数据库

 <insert id="test" parameterType="list">   INSERT INTO abc(a)<foreach collection="list" item="item" index="index" separator="union all">        #{item.a}    </foreach>  </insert> <update id="updateSubmitStatus2" parameterType="map">      update umbp_submit set sendstatus=1  where id in (          <foreach collection="list" item="item" index="index" separator=",">              ${item.id}          </foreach>      )  </update> <insert id="insertUmbpDeliver" parameterType="list">      INSERT INTO umbp_deliver (taskid ,phone ,content ,created ,seqtype, sequenceid ) VALUES    <foreach collection="list" item="item" index="index" separator=",">       (#{item.taskid} ,#{item.phone} ,#{item.content} ,NOW(), #{item.seqtype}, #{item.sequenceid})    </foreach>  </insert>

oracle数据库

<insert id="test" parameterType="list">   INSERT INTO abc(a)<foreach collection="list" item="item" index="index" open="select" separator="union select" close="">        #{item.a} from dual    </foreach>  </insert>