UPDATE 表名 SET 字段名 = REPLACE(替换前的字段值, '替换前关键字', '替换后关键字');
比如:
update province set url = replace(url,"*",null);
删除某一列:delete删除一行:delete from student where id=1
delete删除多行:delete from student where id>1
UPDATE 表名 SET 字段名 = REPLACE(替换前的字段值, '替换前关键字', '替换后关键字');
比如:
update province set url = replace(url,"*",null);
删除某一列:delete删除一行:delete from student where id=1
delete删除多行:delete from student where id>1