MySql数据库——定时删除过期数据

1.创建表
    
    //创建一个表
    CREATE TABLE accountno(

    id INT(10) PRIMARY KEY NOT NULL auto_increment,

    account_number VARCHAR(20) NOT NULL,

    date TIMESTAMP DEFAULT CURRENT_TIMESTAMP

    )；

    //查看定时器是否开启， 

    show variables like 'event_scheduler'; 
    
    如果 event_scheduler Value OFF 

    执行：-- 开启定时器 0：off 1：on 
    SET GLOBAL event_scheduler = 1; 
    
    //每60秒删除过期5分钟的数据
    DROP event IF EXISTS e_delete_wxauth;
    CREATE EVENT e_delete_wxauth
    ON SCHEDULE
    EVERY 60 SECOND
    DO
    DELETE FROM accountno WHERE DATE < DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 5 MINUTE);

    select * from mysql.event;