prod_group_bg/ems/sql/ems_clear_data.sql

-- 定时清理
-- 电表数据
delete from adm_elec_meter_h where create_time < date_sub(now(), interval 365 day);

-- 水表数据
delete from adm_water_meter_h where create_time < date_sub(now(), interval 365 day);