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;

posted @ 2016-06-17 09:07  czcb  阅读(149)  评论(0编辑  收藏  举报