求WHILE循环写法!!急!!!加班中!!1

[renshaohai8810611]

DECLARE I int;
DECLARE J int;
set I=100000;
set J=1;


while I<=120000 do
begin

while J<=10 do
begin

insert into t_favorites values (I,I,I,J,'1','0','100','1','0',now()+0,now()+0,now()+0,now()+0,'1');

if(J=10) then

set J=1;

else
set J=J+1;

end if;
end;
end while;

set I=I + 1;

end;
end while;
end;

报错..请教怎么修改??

[renshaohai8810611]

MYSQL扳快怎么没人应啊???

[mschen]

-- 这样测试OK.

Delimiter $$

Create Procedure P_test()
Begin
DECLARE I int;
DECLARE J int;
set I=100000;
set J=1;
while (I<=120000) do
begin
while (J<=10) do
begin
insert into t_favorites values (I,J) ;
if(J=10) then
set J=1;
else
set J=J+1;
end if;
end;
end while;
set I=I + 1;
end;
end while;
end$$


Call p_test();

[renshaohai8810611]

ERROR 1062 (23000): Duplicate entry '1' for key 1

我在CALL后出现了如下错误...在CALL前已经执行了DELETE语句....

[mschen]

不好意思.

insert into t_favorites values (I,I,I,J,'1','0','100','1','0',now()+0,now()+0,now()+0,now()+0,'1');


上边是你原来的插入语句,换回来就好了.