mysql 语句 循环入数据库

DELIMITER ;; 
CREATE PROCEDURE test_i () 
BEGIN 

DECLARE i INT DEFAULT 1;

WHILE i<400000 
DO 
INSERT INTO `el_pvmi`.`defect_ai_1_tags`(`defect_ai_1_id`, `tag_id`) VALUES (i, 4); 
SET i=i+1; 
END WHILE ; 
commit; 

END;; 

CALL test_i();