UPDATE t_key_word SET key_word = REPLACE(REPLACE(key_word, CHAR(10), ''), CHAR(13), '') 转载于:https://www.cnblogs.com/caer/p/6773220.html