CREATE PROCEDURE `test_insert_stu`()
BEGIN
DECLARE num INT;
SET num = 0;
WHILE (num<10) DO
insert into test_student_info(name) values(concat('zb',num));
set num=num+1;
END WHILE;
END
2021-12-29 21:15:53
CREATE PROCEDURE `test_insert_stu`()
BEGIN
DECLARE num INT;
SET num = 0;
WHILE (num<10) DO
insert into test_student_info(name) values(concat('zb',num));
set num=num+1;
END WHILE;
END