drop procedure if exists jyf_test; DELIMITER ;; CREATE PROCEDURE jyf_test() BEGIN DECLARE a INT UNSIGNED DEFAULT 1; WHILE a <= 20 DO INSERT INTO 。。。。。。; SET a= a+1; END WHILE; COMMIT; END ;; DELIMITER ; CALL jyf_test(); drop procedure if exists jyf_test;