Mysql批量修改字段属性

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' -- 代表所在的数据库
AND data_type in ('decimal')
and column_name not like '%_id'
and (column_name like '%_amount' or column_name like '%_qty')
and table_name like 'shop%'

转载于:https://www.cnblogs.com/iaoc/p/3641245.html