ifnull(p1,p2)
如果p1有值就是p1,如果p1是空,则值为p2
<insert id="insertForeach" parameterType="java.util.List" >
insert into user_message
( skip_id )
values
<foreach collection="list" item="userMessage" index="index" separator=",">
( ifnull(#{userMessage.skipId},"0") )
</foreach>
</insert>
详细分析见:https://blog.csdn.net/weixin_38137028/article/details/88245042