阿里巴巴国际站网页版_景区网站建设教程_互联网营销怎么赚钱_唐山建站公司模板

SELECT CONCAT('ALTER TABLE ', table_name, ' MODIFY COLUMN ', column_name, ' ', COLUMN_TYPE , ' CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ;') 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'your_database' AND COLLATION_NAME is not  null  and COLLATION_NAME !='utf8mb4_general_ci';

执行上面的sql 后 复制出来 批量执行就OK了 记录下