sql_update

时间:2023-12-19 11:12:38

学习:
http://www.runoob.com/mysql/mysql-tutorial.html

replace:
update table_name set column = replace (column,'@',',');
通用语法:
update table_name set column=new_value,column2=new_value1[where clause]
例:
update tm_bargrain_dwj_copy1 set column = concat('0',column) where length(column) = 2;