UPDATE person SET address = trim( replace( `address `, '\r\n', ' ' ) )
参考:http://hi.baidu.com/heaven_line/item/f753b2fa316bbd48932af2e6
UPDATE person SET address = trim( replace( `address `, '\r\n', ' ' ) )
参考:http://hi.baidu.com/heaven_line/item/f753b2fa316bbd48932af2e6