mysql常用的几个操作字段的语句

mysql常用的几个操作字段的语句：

UPDATE tbname SET column_name = '0' WHERE column_name= ''

UPDATE table_name SET column_name = REPLACE(column_name, '符号', '');

SELECT CONVERT(column_name , int) as int FROM tabname