SELECT CONCAT(
'alter table ',
table_name,
' MODIFY COLUMN ',
column_name,
' bigint;'
) AScol,
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE
FROM INFORMATION_SCHEMA.columns a WHERE TABLE_SCHEMA ='xbookplus_md'
AND data_type IN('decimal')
and NUMERIC_SCALE = 30
and NUMERIC_PRECISION = 65;
mysql批量修改数据库字段类型
最新推荐文章于 2023-10-09 15:00:10 发布