sql_update

学习: 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;
posted @ 2018-11-29 11:39  Uhey  阅读(118)  评论(0编辑  收藏  举报