SQL - 事件

-- 创建事件
drop event if exists yearly_delete_stale_audit_rows
delimiter $$
create event yearly_delete_stale_audit_rows
on schedule -- at now() -- 执行一次every 1 year starts '2019-01-01' ends '2025-01-01' -- 定期执行
do begindelete from payments_auditwhere action_date < now() - interval 1 year;
end$$
delimiter ;