drop procedure if exists chuncun;
create procedure chuncun(n int)
begin
declare i int(10) default (select count(*) from user);
declare k varchar(20) default '';
declare j varchar(20) default '';
/*create table user (id int(10) primary key auto_increment,user_name varchar(20),user_pwd int(10),verify varchar(20));
insert into user(id,user_name,user_pwd,verify) values (1,"user1",123456,"w4e38j");
insert into user(id,user_name,user_pwd,verify) values (2,"user2",123456,"w4e39j");
insert into user(id,user_name,user_pwd,verify) values (3,"user3",123456,"w4e40j");*/
if n<=i then
select count(*) from user;
else
while n>i do
set j=(select concat("user",i+1));
set k=(select left(uuid(),6));
insert into user(user_name,user_pwd,verify) values (j,123456,k);
set i=i+1;
end while;
select * from user;
end if;
end
call chuncun(1000)
|
|