-生成批量操作表字段的语句

SELECT -- *, 
 CONCAT('ALTER TABLE `', a.TABLE_SCHEMA, '`.`', a.table_name, '` drop  COLUMN `delete_flag`;')
FROM information_schema.`TABLES` a
WHERE TABLE_SCHEMA = 'xiaobaidb'
AND EXISTS (
 SELECT 1
 FROM information_schema.COLUMNS aa
 WHERE aa.TABLE_SCHEMA = a.TABLE_SCHEMA
 AND aa.table_name = a.table_name
 AND aa.column_name = 'delete_flag'
)