1 配置开启event scheduler
配置my.ini文件 中加上 event_scheduler = 1
重启mysql服务
验证event_scheduler是否已经开启: show variables like '%event%' #值为 ON 表明已开启
2 创建event
drop event event_test_a
CREATE EVENT event_test_a
ON SCHEDULE EVERY 1 day STARTS date_add(concat(current_date(), ' 00:00:00'), interval 0 second)
ON COMPLETION PRESERVE ENABLE
DO
delete from dbname.`user` where (`name`, `time` ) =
(
select `name`, max_time from
(select `name`, max(`time`) max_time from dbname.`user` group by 1) t
where max_time <date_add(current_timestamp, interval -2 month)
)
在phpmyadmin中建个表,再清空,就看到命令咯删库和删表:
drop database 库名
drop table 表名;
7、将表中记录清空:
delete from 表名
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)