使用trim标签,如果是更新的话prefix=“set”,否则为空串即可
举例
INSERT INTO live (
<trim prefix="" suffixOverrides=",">
<if test="creator!=null">
`creator`,
</if>
<if test="createTime!=null">
`createTime`,
</if>
</trim>
) VALUES (
<trim prefix="" suffixOverrides=",">
<if test="creator!=null">
#{creator},
</if>
<if test="createTime!=null">
#{createTime},
</if>
</trim>
)
<selectKey keyProperty="id" order="AFTER" resultType="Long">
SELECT LAST_INSERT_ID()
</selectKey>
</insert>