51CTO博客开发
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
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号