定时清理mysql表数据 event

虚拟机安装maridb做测试，简单快捷。mysql安装教程_懂视生活_懂你更懂生活

建个测试表

create table test_event(
  id int,
  log_time datetime
);

写入测试数据

insert into test_event (id,log_time) values (1,"2021-09-19 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-20 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-21 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-22 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-23 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-24 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-25 00:00:00");
insert into test_event (id,log_time) values (1,"2021-09-26 00:00:00");

创建event

DROP EVENT IF EXISTS deleteLog;
CREATE EVENT deleteLog
O