update table
set 字段名=case when 字段名 is not null
then CONCAT(字段名,"追加的数据")
else "追加的数据" end
where id=1;
12-02
03-26
2809
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-05
3395
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-27
update table
set 字段名=case when 字段名 is not null
then CONCAT(字段名,"追加的数据")
else "追加的数据" end
where id=1;