3.18作业--宝安22期佘扬周
drop procedure if exists baoan22;create procedure baoan22 (n int)
begin
declare i int(5) default(select count(*) from user);#声明变量i int类型的数据 默认值为表中的数据条数
declare j varchar(8) default'zhangsan';#声明变量j varchar类型的数据 默认值为'zhangsan'
declare p varchar(6) default'adxxdd';#声明变量p varchar类型的数据 默认值为'adxxdd'
drop table if exists user;#如果这个表存在则把表删除
create table user (id int(5) primary key auto_increment,user_name varchar(8),
user_pwd int(16) default 123456, verify varchar(6));#建表
insert into user values(1,'zhangsan',123456,'adxxdd');#插入数据
if n<=i then
select count(*) from user;
else
while n>i do
set i=i+1;
set j=(select substring(md5(rand()),1,8));#给变量j随机赋值8字符串
set p=(select substring(md5(rand()),1,6));#给变量j随机赋值6字符串
insert into user(user_name,verify) values(j,p);#插入对应j,p
end while;
end if;
end
call baoan22(1000);
select * from user;
页:
[1]