MySQL 的事件日程

Question

我收到以下错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 7

DELIMITER$$
CREATE EVENT myevs
ON SCHEDULE EVERY 1 DAY

DO 
 BEGIN
   INSERT INTO ww SELECT * FROM fff WHERE dates = NOW()
   DELETE FROM fff where dates = NOW()
END$$

DELIMITER;

Answer 1

insert 和 delete 语句末尾缺少分号 (;):

DELIMITER$$
CREATE EVENT myevs
ON SCHEDULE EVERY 1 DAY

DO 
 BEGIN
   INSERT INTO ww SELECT * FROM fff WHERE dates = NOW();
   -- Here --------------------------------------------^

   DELETE FROM fff where dates = NOW();
   -- And here -----------------------^
END$$

DELIMITER;