摘要： SELECT CONCAT('alter table ', table_name, ' CHANGE ', column_name, ' ', column_name, ' double;') as col, TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.columns a WHERE TABLE_SCHEMA = 'aca' -... 阅读全文