在存储过程中加在什么地方??
delimiter ?
DROP PROCEDURE IF EXISTS t_favorites_111;
?CREATE PROCEDURE t_favorites_111()
BEGIN
set identity_insert t_favorites on;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
begin
set J=1;
set I=I+1;
end;
else
set J=J+1; end if;
END;
END WHILE;
END;
END WHILE;END;
call t_favorites_111();
?
delimiter ?
DROP PROCEDURE IF EXISTS t_favorites_111;
?CREATE PROCEDURE t_favorites_111()
BEGIN
set identity_insert t_favorites on;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
begin
set J=1;
set I=I+1;
end;
else
set J=J+1; end if;
END;
END WHILE;
END;
END WHILE;END;
call t_favorites_111();
?
create table test.tt(id int auto_increment primary key);insert into test.tt values(1), (2), (3), (8);select * from test.tt;insert into test.tt values(7);select * from test.tt;insert into test.tt values(default);select * from test.tt;
这个错误呢? 插入重复值????