如下:
INSERT INTO my_occur_hist (
id,
flow_id,
aid,
processor,
node,
STATUS,
result,
last_flow_id,
last_processor,
last_result,
created_time,
updated_time
)
VALUES
<foreach item="item" collection="list" open="(" separator="," close=")">
NULL,
#{item.flowId},
#{item.aid},
#{item.processor},
#{item.node},
#{item.status},
#{item.result},
#{item.lastFlowId},
#{item.lastProcessor},
#{item.lastResult},
NOW(),
NOW()
</foreach>
这样,批量插入的时候老是出问题,一个个都插入的时候,没有问题,是为什么??
相关分类