我肯定做了什么非常愚蠢的事情,但以下内容是正确的:
CREATE EVENT delete_old
ON SCHEDULE
EVERY 1 DAY
COMMENT 'Clears old cache data from the DB.'
DO
DELETE FROM summoners
WHERE `date` < (NOW() - INTERVAL 7 DAY);
下一部分的问题似乎出现了语法错误,最后2行出现了问题:
CREATE EVENT delete_old
ON SCHEDULE
EVERY 1 DAY
COMMENT 'Clears old cache data from the DB.'
DO BEGIN
DELETE FROM summoners
WHERE `date` < (NOW() - INTERVAL 7 DAY);
END;
据我所知,语法是正确的,但是MySQL Workbench不认同。我打算在BEGIN - END部分内做多个表格,这就是为什么我需要它。我希望有人能够找出问题所在,我很困惑。谢谢您提前的帮助,Smiley。