Mysql 批量修改表格字段字符编码

修改数据库和单个表格的编码可以网上搜索，以下是针对表格字段的编码修改快速生成，并用于字段编码调整

SELECT 
CONCAT("ALTER TABLE `", TABLE_NAME,"` CHANGE  `",COLUMN_NAME,"` `",COLUMN_NAME,"` ",COLUMN_TYPE,"  CHARACTER SET utf8 COLLATE utf8_general_ci ",IF(IS_NULLABLE='YES','NULL','NOT NULL' )," DEFAULT ",IF(ISNULL(COLUMN_DEFAULT),"NULL",CONCAT("'",COLUMN_DEFAULT,"'") )," COMMENT '",COLUMN_COMMENT, "';") 
AS target_tables
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA="数据库" # 修改为需要更改的数据库名称
AND DATA_TYPE LIKE '%数据类型%' AND TABLE_NAME ='单个表' # 如果需要多个表格，可以去除最后这个条件