UPDATE user_info SET id_card=REPLACE(id_card,CHAR(13),''); char(10): 换行符char(13): 回车符 转载于:https://www.cnblogs.com/fengjunkuan/p/4311238.html