存储过程实战演练3.27

drop procedure if exists haha;
create procedure haha(n int)
begin
        declare w int(10) default (select count(*) from user);
        declare i varchar(10) default " ";
        declare j varchar(10) default " ";
       
        drop table if exists user;
   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,"a9a9a9");
         select * from user where id = n;
if n<=w then
          select count(*) from user;
  else
    while n>w do
                 set i =(select concat("user",w+1));
                 set j = (select left(uuid(),6));
                 insert into user(user_name,user_pwd,verify) values(i,123456,j);
                 set w=w+1;
                 end while;
                 select * from user;

        end if;



end

call haha(1000)