未声明则不插入
create_time是自动注入字段
xml是最终执行的sql命令,未声明加入则不会插入
<insert id="insertListIfNotExists" useGeneratedKeys="true" keyProperty="id">
INSERT IGNORE INTO
`tag` (name)
VALUES
<foreach collection="list" item="item" separator=",">
(#{item.name})
</foreach>
</insert>
修改:
<insert id="insertListIfNotExists" useGeneratedKeys="true" keyProperty="id">
INSERT IGNORE INTO
`tag` (name, create_time)
VALUES
<foreach collection="list" item="item" separator=",">
(#{item.name}, #{item.createTime})
</foreach>
</insert>