mysql 批量更新数据库主键为int，bigint 类型，字段为自增类型
标签：sch lte post orm sel blog key cat from
mysql 批量更新数据库主键为int，bigint 类型，字段为自增类型
table_name,
concat(‘alter table `‘,table_name,‘` MODIFY ‘, column_name, ‘ ‘, data_type ,‘ auto_increment;‘) as ‘query script‘
from information_schema.columns c
where c.table_schema = ‘pv_2‘
and c.column_key =‘PRI‘
and c.data_type in ( ‘int‘,‘bigint‘)
and c.extra <> ‘auto_increment‘
order by table_name;