批量插入原生sql,形如:
insert into users (name, age) values ("AA", 1), ("BB", 2);
批量插入mybatis拼接的语句示例:
<insert id="insertBatch" parameterType="java.util.List">
INSERT INTO
ecarx_ota_task_detail
(id, task_id, vin, sn)
VALUES
<foreach collection="list" item="ota_task_detail" separator=",">
(
#{ ota_task_detail.id} , #{ota_task_detail.taskId} , #{ota_task_detail.vin}
)
</foreach>
</insert>