3.18作业
drop procedure if exists test;create procedure test(n int)
BEGIN
declare i int(20) default(select count(*) from user);
declare x varchar(10) default" ";
declare y varchar(10) default" ";
drop table if exists user;
create table user
(id int(20)primary key auto_increment,
user_name varchar(20),
user_pwd int(20)default"123456",
verify varchar(20));
insert into user values(1,"user1",123456,"W4E38J");
if i >= n THEN
select count(*) from user;
else
while i < n DO
set i = i + 1;
set x = (select concat("user",i));
set y = (select substr(md5(rand()),1,6));
insert into user (user_name,verify) values (x,y);
end while;
end if;
END
call test(1000);
select*from user;
页:
[1]