Automatic TRUNCATE table in MySQL

Question

I am looking for a way to automatically clean table in MySQL once per day. Is this possible without using cron? The best solution would be a trigger, but any solution is applicable.

Triggers should be avoided when possible. They typically create more issues when it comes to maintenance. — Kermit, Feb 22 '14 at 15:35

score 18 · Accepted Answer · answered Feb 22 '14 at 15:29

18

One option is MySQL's EVENT scheduler:

CREATE EVENT e_daily
    ON SCHEDULE
        EVERY 1 DAY
        STARTS '2014-02-23 05:00:00' -- Time to start
    COMMENT 'Descriptive comment'
    DO
        TRUNCATE yourtable;

How to enable event scheduler

answered Feb 22 '14 at 15:29

Kermit

33,827
13
85
121

3

Don't forget to 'set global event_scheduler=on', which is off by default. – Sunry Jul 19 '15 at 08:28

Automatic TRUNCATE table in MySQL

1 Answers1

Linked