mysql设置定时任务

CREATE DEFINER = `hpjj_root`@`%` EVENT `del_dwd_dz_cs_tcccwxx_df` ON SCHEDULE EVERY 10 SECOND STARTS '2020-08-24 10:00:00' ON COMPLETION PRESERVE ENABLE COMMENT '每10秒执行一次删除，每次删除1000条' DO
    DELETE
FROM
    dwd_dz_cs_tcccwxx_df
WHERE
    hqsj < DATE_SUB(now(), INTERVAL 31 DAY)
LIMIT 1000