TABLE_SCHEMA为数据库名称
style amp mysq orm alt inf time columns where
select column_name,data_type,CONCAT('alter table `',table_name,'` modify column `',column_name,'` datetime;')
from information_schema.`COLUMNS`
where TABLE_SCHEMA='pv_2'
and data_type = 'timestamp';
data_type为条件数据类型
datetime为目标数据类型
mysql 批量更新数据类型
来源: http://www.bubuko.com/infodetail-2462737.html