具体步骤如下： 1：超级用户方式登陆MySQL console ``` \# mysql　-uroot -p ``` 2：打开```event\_scheduler```(默认是关掉的) ``` mysql> set global event\_scheduler = ON; ``` 3：创建我们的事件(例子 命名为delete\_old\_record) ``` mysql> CREATE EVENT delete\_old\_record ``` 然后编写脚本 DO \-- delete the old records of demo\_1\_table ``` DELETE FROM demo\_1\_table WHERE datediff(NOW(),log\_timestamp)>=7; ``` \-- delete the old records of puma\_2\_table ``` DELETE FROM demo\_2\_table WHERE datediff(NOW(),log\_timestamp)>=7; ``` 4：启动创建的事件 ``` mysql> ALTER EVENT delete\_old\_record ENABLE; ``` 这样以后，数据库就会每天执行DO后面的作业，删除各个table中7天之前的记录。