MySQL 关闭FOREIGN_KEY_CHECKS检查

SET FOREIGN_KEY_CHECKS=0;
truncate table QRTZ_BLOB_TRIGGERS;
truncate table QRTZ_CALENDARS;
truncate table QRTZ_CRON_TRIGGERS;
truncate table QRTZ_FIRED_TRIGGERS;
truncate table QRTZ_JOB_DETAILS;
truncate table QRTZ_LOCKS;
truncate table QRTZ_PAUSED_TRIGGER_GRPS;
truncate table QRTZ_SCHEDULER_STATE;
truncate table QRTZ_SIMPLE_TRIGGERS;
truncate table QRTZ_SIMPROP_TRIGGERS;
truncate table QRTZ_TRIGGERS;

原文地址:https://www.cnblogs.com/zhaoyangjian724/p/6199847.html