3.18作业 user表--存储过程
本帖最后由 宝安22班-陈妮华 于 2022-3-18 23:47 编辑drop procedure if exists up;
create procedure up(n int)
BEGIN
declare i int(10) default(select count(id) from user);
declare a varchar(10) default(select user_name from user);
declare b varchar(10) default(select verify from user);
drop table if exists user;
create table user(id int(10) primary key auto_increment,
user_name varchar(10),user_pwd int(10) default 123456,verify varchar(10));
insert into user values(1,'user1',123456,'W4E38J');
if n<=i THEN
select count(id) from user;
ELSE
while n>i DO
set i =i+1;
set a =(select concat('user',i));
set b =(select substring(md5(rand()),1,6));
insert into user(user_name,verify) values(a,b);
end while;
end if;
select * from user;
END
call up(1000);
select * from user;
页:
[1]