未声明则不插入

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>