mysql一次insert多条写法:
insert into oa_send (id, docid, sendid, sendname, nodetype, type) VALUES
( '2b69823f1d964e049ca4b96832212d4b', '0b6c52740aae47189fa61afe9c60ca7d', '1f3c92ca-0cc5-4954-842a-933c0acf482d#4', '赵'
, '', 'leaderSend' ),
( '1b69823f1d964e049ca4b96832212d4b', '0b6c52740aae47189fa61afe9c60ca7d', '1f3c92ca-0cc5-4954-842a-933c0acf482d#4', '赵'
, '', 'leaderSend' );
在Oracle中不能使用values(),()这样的写法
解决办法:
在mybatis中批量添加
<insert id="insertByList" parameterType="list">
insert all
<foreach collection="list" item="item" index="index" separator="" >
into oa_send
(id,
docid,
sendid,
sendname,
nodetype,
type)
VALUES
(
#{item.id,jdbcType=VARCHAR},
#{item.docid,jdbcType=VARCHAR},
#{item.sendid,jdbcType=VARCHAR},
#{item.sendname,jdbcType=VARCHAR},
#{item.nodetype,jdbcType=VARCHAR},
#{item.type,jdbcType=VARCHAR}
)
</foreach>
select 1 from dual
</insert>