1.利用系统表,查询出含有指定类型的字段,表清单
SELECT
TABLE_NAME,
TABLE_SCHEMA,
column_name,
DATA_TYPE,
column_comment
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '数据库名称'
AND DATA_TYPE = '字段类型'
2.使用concat拼接sql语句
SELECT
TABLE_NAME,
TABLE_SCHEMA,
column_name,
DATA_TYPE,
column_comment,
CONCAT( 'alter table ', TABLE_NAME, ' alter column ', column_name, ' set default 0; ' )
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'fast_insure_loan'
AND DATA_TYPE = 'decimal'
3.批量执行语句
左击这一行复制sql (ctrl c)
ctrl v
批量执行
over 给个赞吧
转载写明出处 谢谢