方案一: 使用SQL删除
SET group_concat_max_len = 1000000; -- 防止语句过长报错（可选）
SELECT CONCAT('DROP TABLE IF EXISTS ', GROUP_CONCAT(table_name), ';')
INTO @sql
FROM information_schema.tables
WHERE table_schema = DATABASE();
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
方案2: 直接删除库再新建
drop database_name;
create database database_name;
a
