sqlyog 亲测有效
DROP PROCEDURE IF EXISTS test;
DELIMITER$$
CREATE
PROCEDURE `db_homework`.`test`()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i < 4 DO INSERT INTO `t_book`(bookName, author, price) VALUE('11', '11', '11');
SET i = i + 1;
END WHILE;
END$$
DELIMITER ;
CALL test();
仅供自己学习