- 生成删除的sql
SELECT
concat(
'DROP TABLE IF EXISTS ',
table_name,
';'
)
FROM
information_schema. TABLES
WHERE
TABLE_NAME IN (
...
);
复制代码
- 进行删除
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS tablename;
DROP TABLE IF EXISTS tablename;
SET FOREIGN_KEY_CHECKS = 1;
复制代码