请教一个mysql event的问题
0
悬赏园豆：20
[待解决问题]
我在测试,想创建一个event,每5秒插入2条数据,SQL如下:
CREATE EVENT STAT
ON SCHEDULE EVERY 5 SECOND
enable
DO
begin
insert into a (snum) values(1);
insert into a (snum) values(2);
end
执行后提示:
[Err] 1064 - 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 '' at line 6
请问怎么改呢?
所有回答(2)
0
报的是语法错误
嗯。。可是这样写哪里有错啊，工具的提示看不出来是哪错了，语法看起来也正确
