mysql存储过程报错_mysql中存储过程报错

编写的存储过程如下:createprocedurepplog.addUser()begindeclareintcount1default0;ifcount1<1000000thensetcount1=count1+1;insertintopplog.user_log_inf(infohash,filesize,userI...

编写的存储过程如下:

create procedure pplog.addUser()

begin

declare int count1 default 0;

if count1<1000000 then

set count1=count1+1;

insert into pplog.user_log_inf(infohash,filesize,userIp,start_time,end_time,download,total_visit,protocal)

values("3662HDSH",232,'10,23,351',"2010-04-15 10:13:04","2010-05-15 11:34:40",22,33,44);

else set count1=count1+10;

end if;

end;

报错信息如下:

mysql>

mysql> create procedure pplog.addUser()

-> begin

-> declare int count1 default 0;

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 'int count1 default 0' at line 3

mysql> if count1<1000000 then

-> set count1=count1+1;

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 'if count1<1000000 then

set count1=count1+1' at line 1

mysql> insert into pplog.user_log_inf(infohash,filesize,userIp,start_time,end_time,download,total_visit,protocal)

-> values("3662HDSH",232,'10,23,351',"2010-04-15 10:13:04","2010-05-15 11:34:40",22,33,44);

ERROR 1146 (42S02): Table 'pplog.user_log_inf' doesn't exist

mysql> else set count1=count1+10;

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 'else set count1=count1+10' at line 1

mysql> end if;

展开