mysql循环

-- DROP PROCEDURE test_insert
DELIMITER ;; 
CREATE PROCEDURE test_insert () 
BEGIN 

DECLARE i INT DEFAULT 1;

WHILE i<500 
DO 
insert into areainfo VALUES (i,"province","city","area",10086+i);
SET i=i+1; 
END WHILE ; 
commit; 

END;; 

CALL test_insert();