<trim>的用法

最新推荐文章于 2024-09-08 16:19:39 发布

风清扬兮

最新推荐文章于 2024-09-08 16:19:39 发布

阅读量1.9k

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/zjy974917121/article/details/104528325

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

update table
    <trim prefix="SET" suffixOverrides=",">
        <if test="items != null and items != ''">items = #{items},</if>
        <if test="publishDate != null">publish_date = #{publishDate},</if>
        <if test="name != null and name != ''">name = #{name},</if>
        <if test="area != null and area != ''">area = #{area},</if>
        <if test="address != null and address != ''">address = #{address},</if>
        <if test="zipcode != null and zipcode != ''">zipcode = #{zipcode},</if>
    </trim>