MySQL UPDATE 将数据追加到列中

2022-01-17 00:00:00 sql-update append mysql

我需要更新表名 (col1name)

I need to UPDATE tablename (col1name)

如果已经有数据，我需要附加值'a，b，c'如果它是NULL，我需要添加值'a，b，c'

If there is already data, I need to append it with values 'a,b,c' If it is NULL, I need to add the values 'a,b,c'

我知道有一个 CONCAT 参数，但不确定 SQL 语法是什么.

I know there is a CONCAT argument, but not sure what the SQL syntax would be.

更新表名 set col1name = concat(ifnull(col1name, 'a,b,c'), 'a,b,c')

上面说的对吗?

推荐答案

试试这个查询:

update tablename set col1name = concat(ifnull(col1name,""), 'a,b,c');

参考这个 sql fiddle 演示.

相关文章