我的代码如下,虽然显示出错,但是操作结果又是正确的,这是怎么回事咧?
mysql> delimiter $
mysql> create procedure add_time(OUT result int)
-> begin
-> update time set time_id=time_id+1 where user_id=2;
-> end$
Query OK, 0 rows affected (1.13 sec)mysql> SET GLOBAL event_scheduler = 1;
-> $
mysql> create event time_ev on schedule every 5 second
-> do
-> call add_time(@result);
-> end$
Query OK, 0 rows affected (0.00 sec)
ERROR 1064 (42000): 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 1
mysql> delimiter $
mysql> create procedure add_time(OUT result int)
-> begin
-> update time set time_id=time_id+1 where user_id=2;
-> end$
Query OK, 0 rows affected (1.13 sec)mysql> SET GLOBAL event_scheduler = 1;
-> $
mysql> create event time_ev on schedule every 5 second
-> do
-> call add_time(@result);
-> end$
Query OK, 0 rows affected (0.00 sec)
ERROR 1064 (42000): 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 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货