[mysql] 2024-04-30 圈点302
摘要: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
下一篇[mysql]