创建mysql 存储过程

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