删除空数据 DELETE FROM `nm_codes` WHERE `code` LIKE CONVERT(_utf8 '%<nm:name></nm>%' USING gbk) COLLATE gbk_chinese_ci 删除ERROR数据 DELETE FROM `nm_codes` WHERE `code` LIKE CONVERT(_utf8 'error' USING gbk) COLLATE gbk_chinese_ci 替换分类…