xian01 3.27作业

create table user (id int(10) primary key auto_increment,user_name varchar(10),user_pwd int(10),verify varchar(10));
insert into user (id,user_name,user_pwd,verify)values(1,"user1",123456,"w4e38j");
drop procedure if exists insert_user;
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=(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)