CREATE PROCEDURE `prc_del_dp_product_data_time`(IN date_inter int) COMMENT '自动删除7天前的数据'
BEGIN
delete from dp_product_data_time where (TO_DAYS(NOW()) - TO_DAYS(datatime))>=date_inter;
END;
CREATE EVENT auto_delete_dp_product_data_time
ON SCHEDULE EVERY 1 DAY
STARTS '2018-11-13 10:50:00'
ON COMPLETION PRESERVE ENABLE COMMENT '自动删除7天前的数据' DO call prc_del_dp_product_data_time(7)