DECLARE classid char(36); #主键 #
declare stuid char(36);
declare classnamehead varchar(50) default 'c'; #机构id#
declare num int default 500; #为N个机构创建预约记录,每个机构的预约数为N#
declare temp int default 300; #temp被赋值为N,为机构创建N条预约数#
start transaction;
#为N个机构创建预约记录,每个机构的预约数为N#
while num>0 DO
set classid=uuid();
INSERT INTO class values(classid,concat(classnamehead,num),0,CURRENT_TIMESTAMP);
-- set temp=30;
while temp>0 DO
set stuid=uuid();
insert into student values(stuid,concat('stuname',classid,'-',temp),CURRENT_TIMESTAMP,'arrrrrr',CURRENT_TIMESTAMP,0,classid,'');
SET temp=temp-1;
end WHILE;
set num=num-1;
-- SET institition_id = institition_id-5;
END WHILE;
批量插入数据
最新推荐文章于 2024-09-30 14:17:39 发布