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();
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。