阅读过去,思考未来。面向信仰编程
替换回车换行符:
UPDATE tablename SET title = REPLACE(REPLACE(fieldname, '\r', ''), '\n', '');