MySQL 去除字段空格

MySQL 去除字段中字符串空格

备份数据库,备份数据库,备份数据库;

select * from sys_user;

select name from sys_user;
新字段保留原字段数据:
update sys_user set name_his = name ;
替换前验证:
select replace(name_his,’ ‘,’’) from sys_user;
替换:
update sys_user set name = replace(name,’ ‘,’’) ;
验证:
select name from sys_user;