1.批量修改my_test库所有表的del_flag字段类型、大小、注释 SELECT CONCAT('alter table ',table_name,' modify column del_flag char(1) COMMENT \'删除标识(1正常 0删除)\';') FROM information_schema.COLUMNS where table_schema='my_test' and column_name ='del_flag' 2.复制sql执行