删除空数据
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
替换分类 替换国产剧为 连续剧
UPDATE nm_movies
SET cat
= 'gcj' WHERE cat
LIKE CONVERT(_utf8 'lxj' USING gbk) COLLATE gbk_chinese_ci
替换无分类为国产剧
UPDATE nm_movies
SET cat
= 'gcj' WHERE cat
LIKE CONVERT(_utf8 '' USING gbk) COLLATE gbk_chinese_ci