调用存储过程错误

nianzhang747 2009-09-08 10:55:17

mysql> delimiter //
mysql> create procedure tt()
-> begin
-> declare id integer;
-> set id=1;
-> while(id<300)
-> do
-> set id=id+1;
-> set @ee= concat ("insert into url(urladdr) values('

')","");
-> end while;
-> prepare ee from @v_flag;
-> EXECUTE ee ;
-> DEALLOCATE PREPARE ee;
-> end;
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call tt();
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 'NULL
at line 1
mysql>

...全文

106 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

nianzhang747 2009-09-09

打赏
举报

nianzhang747 2009-09-09

打赏
举报

nianzhang747 2009-09-09

打赏
举报

delimiter //
create procedure tt()
begin
declare id integer;
set id=1;
while(id <300)
do
set id=id+1;
set @ee= concat("insert into url(urladdr) values('

')"," ");
prepare v_flag from @ee;
EXECUTE v_flag;
DEALLOCATE PREPARE v_flag;
end while;
end;
//
OK 3Q

阿_布 2009-09-09

打赏
举报

给你修改了一下：



delimiter // 

create procedure tt() 

 begin 

 declare id integer; 

  set id=1; 

  while(id <300) 

  do 

  set id=id+1; 

  set @ee= concat("insert into url(urladdr) values('')"," "); 

  prepare v_flag from @ee; <--v_flag放在前面，后面是语句

  EXECUTE v_flag; 

  DEALLOCATE PREPARE v_flag; 

  end while; 

 end; 

//

nianzhang747 2009-09-08

打赏
举报

drop procedure if exists tt;
delimiter //
create procedure tt()
begin
declare id integer;
set id=1;
while(id<300)
do
set id=id+1;
set @ee= concat ("insert into url(urladdr) values('