DROP EVENT IF EXISTS e_del_7days;

CREATE EVENT e_del_7days

ON SCHEDULE EVERY 60 MINUTE STARTS TIMESTAMP '2019-05-24 05:00:00'

DO

DELETE FROM data_a50 WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_bbb WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_btc WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_cl WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_gc WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_ltc WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_oil WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_ry WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_xau WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;

DELETE FROM data_yb WHERE TO_DAYS(NOW()) - TO_DAYS(time) > 7 ;