MySQL timed events

1. Create a test table

CREATE TABLE TIMESTAMP);

2. Create an event: Insert a record into the datasheet every second

CREATEon1  SECOND  INSERTintoVALUES ( current_timestamp);

3. Clear the AAA table regularly every day:

-- Daily Timing Status AAA table CREATE  on 1  Day  timestamp'2016-12-19 12:00:00'truncate table AAA;

4. Daily AAA table, 5 days after the execution of the stop

-- 5 days after the day of the AAA table, stop execution Drop if exists e_test; Create Event E_test  on 1  Day  current_timestamp+5Daytruncate table AAA;

5.5 days after the start of the daily emptying test table, after one months to stop execution

-- 5 days after the start of the daily emptying test table, after one months to stop execution CREATE  on1daycurrent_timestamp+5Day  current_timestamp + 1 MONTHTRUNCATE    TABLE aaa;

MySQL timed events