- 获取删除语句
SELECT CONCAT( 'drop table ', table_name, ';' )
FROM information_schema.tables
WHERE table_schema='数据库名' AND table_name LIKE '模糊表名%';
示例:
SELECT CONCAT( 'drop table ', table_name, ';' )
FROM information_schema.tables
WHERE table_schema='db1' and table_name LIKE 'table_name_%';
- 复制 输出的结果 再运行删除