批量插入测试数据的存储过程
DROP PROCEDURE IF EXISTS procInStu;
CREATE PROCEDURE procInStu()
BEGIN
DECLARE var INT;
DECLARE stuCode char(8);
DECLARE sc int;
DECLARE stuName VARCHAR(6);
SET var=0;
WHILE var<6000 DO
set stuCode = concat('2020', lpad(var,4,'0'));
set stuName = concat('李', rpad(var,3,'0'));
set sc = ROUND(RAND() * 50 + 50);
INSERT INTO student(stu_code,stu_name,dep_code,score) VALUES (stuCode,stuName,'TEST02',sc);
SET var=var+1;
END WHILE ;
END;
call procInStu();