mysql批量删除表

mysql批量删除表

1. 查询构建所有的删除语句

SELECT CONCAT('drop table ',table_name,';')
FROM information_schema.TABLES
WHERE table_name LIKE 'fine_%';

2. 复制查出来的删除sql语句，并批量执行

drop table QRTZ_BLOB_TRIGGERS;
drop table QRTZ_CALENDARS;
drop table QRTZ_CRON_TRIGGERS;
drop table QRTZ_FIRED_TRIGGERS;
drop table QRTZ_JOB_DETAILS;
drop table QRTZ_LOCKS;
drop table QRTZ_PAUSED_TRIGGER_GRPS;
drop table QRTZ_SCHEDULER_STATE;
drop table QRTZ_SIMPLE_TRIGGERS;
drop table QRTZ_SIMPROP_TRIGGERS;
drop table QRTZ_TRIGGERS;

删除完成！