利用replace()函数将换行符【char(10)】和回车符【char(13)】替换为空串UPDATE tablename SET field = REPLACE(REPLACE(field, CHAR(10), ''), CHAR(13), '');char(10): 换行符char(13): 回车符
