mysql -----------查询表数量，删除多表

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES
WHERE table_schema = 'b_pmi' GROUP BY table_schema;

SELECT CONCAT("DROP TABLE ", TABLE_NAME, ";")
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = "b_pmi" AND TABLE_NAME LIKE "t_oa_%";