create table user (id int(10) primary key auto_increment,
user_name varchar(10),
user_pwd varchar(10),
verify varchar(10));
insert into user(id,user_name,user_pwd,verify)values(1,"user1",123456,"W4E38J");
create procedure insert_user(n int)
begin
declare i int(10)default (select count(*) from user);
declare j varchar(10)default"";
declare k varchar(10)default"";
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 insert_user(1000);
|
|