create procedure addAllStu()
BEGIN
DECLARE n int;
DECLARE ch int;
DECLARE ma int;
DECLARE eng int;
DECLARE info int;
// declare:声明变量
set n=1;
// set:给变量赋值
while n<=50 do
set ch=floor(rand()*100);
set ma=floor(rand()*100);
set eng=floor(rand()*100);
set info=floor(rand()*100);
// floor取整函数
insert into t_students values(CONCAT('stu0',n),CONCAT('学生',n),ch,ma,eng,info,'xx');
// CONCAT 连接字符串
set n=n+1;
end while;
end
创建存储(procedure)
最新推荐文章于 2024-07-08 01:08:30 发布