Monthly Archives: 05月 2017

清除mysql数据库表中的异常空格字符串

2017-05-02 by Jinyang | No Comments | Filed in 技术相关

UPDATE english_words_5000_double SET word = REPLACE(word, ‘\t’, ” );commit; UPDATE english_words_5000_double SET word = REPLACE(word, ‘\n’, ” );commit; UPDATE english_words_5000_double SET word = REPLACE(word, ‘\r’, ” );commit; UPDATE english_words_5000_double SET word = REPLACE(word, ‘ ‘, ” );commit; UPDATE english_words_5000_double SET word1 = unhex(REPLACE(hex(word1), ‘C2A0’, ” )), word2 = unhex(REPLACE(hex(word2), ‘C2A0’, ” ));commit; UPDATE english_words_5000_double SET […]

返回顶部