Question

mysql中存储过程报错

编写的存储过程如下:
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;

Answer 1

帮你改了一下

DELIMITER $$

create procedure pplog.addUser()
begin
declare count1 int 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$$

DELIMITER ;

Answer 2

把你的双引号都换成单引号试试