mysql中有一个字段后面多了'\r\n',需要删除 update poems set author = replace(author,'\r\n',''); 转载于:https://www.cnblogs.com/silenceli/p/3911125.html