Skip to content

QueenieCplusplus/SQL_Event_Scheduler

Folders and files

NameName
Last commit message
Last commit date

Latest commit

8944691 · Jun 3, 2020

History

2 Commits
Jun 3, 2020

Repository files navigation

SQL_Event_Scheduler

MySQL 事件觸發器

CREATE EVENT < event_name >
    ON SCHEDULE < EVERY 1 DAY STARTS CURRENT_TIMESTAMP >
    DO 
       DELETE FROM `mytable` WHERE `publish_date` /*Event Body*/

Releases

No releases published

Packages

No packages published