学习:
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;sql_update
原文:https://www.cnblogs.com/Uhey/p/10037313.html