一、替换信息,执行SQL;
SELECT
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
COLUMN_COMMENT,
CONCAT( 'ALTER TABLE ', table_name, ' MODIFY COLUMN ', COLUMN_NAME, ' varchar(', CHARACTER_MAXIMUM_LENGTH, ');' )
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '库名'
AND data_type = '原字段类型'
二、将查询拼接的SQL复制到执行窗口即可;