mysql数据库定时事件

CREATE PROCEDURE DELETE_Data()
BEGIN
delete FROM `new_energy_plc` where INPUTTIME<date_add(now(),interval-6 day);
delete from cd_ret_well_collect where INPUTTIME<date_add(now(),interval-6 day);
delete from new_energy_plc where INPUTTIME<date_add(now(),interval-6 day);
delete from microgrid_energy_storage_pry where INPUTTIME<date_add(now(),interval-6 day);
delete from photovoltaic_pv where sample_time<date_add(now(),interval-6 day);
delete from energy_storage_battery where sample_time<date_add(now(),interval-6 day);
delete from energy_storage_inverter where sample_time<date_add(now(),interval-6 day);
delete from anti_islanding where sample_time<date_add(now(),interval-6 day);
END;

CREATE EVENT IF NOT EXISTS DELETE_EVENT
ON SCHEDULE EVERY 1 DAY STARTS '2025-02-25 21:30:00'
ON COMPLETION PRESERVE
do call DELETE_Data();