Skip to content

Instantly share code, notes, and snippets.

@johnnian

johnnian/clear_h2.sql

Last active August 31, 2017 01:41
Show Gist options
  • Save johnnian/0d54713b5e8b86800ba2af69884f48e4 to your computer and use it in GitHub Desktop.
Save johnnian/0d54713b5e8b86800ba2af69884f48e4 to your computer and use it in GitHub Desktop.
Download ZIP
Quartz H2数据库清空脚本
Raw
clear_h2.sql
delete from QRTZ_TRIGGERS where 1=1;
delete from QRTZ_SIMPLE_TRIGGERS where 1=1;
delete from QRTZ_SIMPROP_TRIGGERS where 1=1;
delete from QRTZ_BLOB_TRIGGERS where 1=1;
delete from QRTZ_CRON_TRIGGERS where 1=1;
delete from QRTZ_FIRED_TRIGGERS where 1=1;
delete from QRTZ_SCHEDULER_STATE where 1=1;
delete from QRTZ_CALENDARS where 1=1;
delete from QRTZ_LOCKS where 1=1;
delete from QRTZ_PAUSED_TRIGGER_GRPS where 1=1;
delete from QRTZ_JOB_DETAILS where 1=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment