select
CONCAT('ALTER TABLE ',a.TABLE_NAME,' MODIFY COLUMN standard_code varchar(20) NOT NULL COMMENT "标准编码";')
from
INFORMATION_SCHEMA.Columns a
where
TABLE_SCHEMA like 's%' --库名
and COLUMN_NAME = 'code'
执行后生成sql语句
s 库
ALTER TABLE xxx1 MODIFY COLUMN code varchar(20) NOT NULL COMMENT "标准编码";
ALTER TABLE xxx2 MODIFY COLUMN code varchar(20) NOT NULL COMMENT "标准编码";