SELECT
concat( 'ALTER TABLE ', '表名', ' CHANGE COLUMN ', COLUMN_NAME, ' ', LOWER( COLUMN_NAME ), ' ', COLUMN_TYPE, ' COMMENT ''', COLUMN_COMMENT, ''';' ) AS '修改脚本'
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名'
AND TABLE_NAME = '表名';
将脚本中的数据库名和表名修改成对应值执行后将结果复制出来执行即可