您可以直接在SQL中替换它们，方法是在末尾匹配"\ r"，然后替换该"\ r".

You can replace these directly from SQL by matching "\r" at the end, then replacing that "\r".

示例:

UPDATE Person SET firstName = REPLACE(firstName, '\n', '')
where firstName LIKE '%\n'

或

UPDATE Person SET firstName = REPLACE(firstName, '\r', '')
where firstName LIKE '%\r'