在Oracle中,insert批量插入数据:
INSERT ALL
INTO A(field_1,field_2) VALUES (value_1,value_2)
INTO A(field_1,field_2) VALUES (value_3,value_4)
INTO A(field_1,field_2) VALUES (value_5,value_6)
SELECT 1 FROM DUAL;
在mybatis中,insert批量插入数据:
<insert id="insertReceiveDataRecords" useGeneratedKeys="false">
insert all
<foreach item="item" index="index" collection="list">
into mon_receive_data_record
(
<include refid="receiveDataRecordVo"/>
)
values
(
#{item.id,jdbcType=VARCHAR},
#{item.airport,jdbcType=VARCHAR},
#{item.system,jdbcType=VARCHAR},
#{item.relateTable,jdbcType=VARCHAR},
#{item.sendTime,jdbcType=DATE},
#{item.createTime,jdbcType=DATE},
#{item.createUser,jdbcType=VARCHAR},
#{item.modifyTime,jdbcType=DATE},
#{item.modifyUser,jdbcType=VARCHAR},
#{item.isDel,jdbcType=INTEGER}
)
</foreach>
SELECT 1 FROM DUAL
</insert>