论坛 › MySQL运维 › mysql - 去除空格回车符

23323112 发表于 2016-10-21 09:10:58

mysql - 去除空格回车符

                      mysql 通过Excel导入导出数据时,有可能会添加上不需要的空格，回车字符。

UPDATE user SET user_name = TRIM(user_name);
UPDATE user SET user_name = REPLACE(REPLACE(user_name,CHAR(10),''), CHAR(13),'');
UPDATE user SET user_name = REPLACE(user_name, '\n','');
UPDATE user SET user_name = REPLACE(user_name, '\r\n','');

                   

查看完整版本: mysql - 去除空格回车符