select
concat(
'alter table ',
t.table_name,
' MODIFY ',
t.COLUMN_NAME,
' varchar(50);'
)
from
information_schema.`COLUMNS` t
where
t.TABLE_NAME LIKE 'BH%'//表名
and t.table_schema='edp'//数据库名
and t.data_type != 'varchar'
根据上面sql,生成alter的sql
alter table bh_alloca_rule MODIFY CREATE_TIME varchar(50);
alter table bh_alloca_rule MODIFY UPDATE_TIME varchar(50);
alter table bh_asset_class MODIFY CREATE_TIME varchar(50);