通过存储过程插入大批量数据

DROP PROCEDURE IF EXISTS my_insert;
CREATE PROCEDURE my_insert()
BEGIN
   DECLARE n int DEFAULT 0;
        loopname:LOOP
            INSERT INTO bloginfo(blogAuthor,blogUrl,blogTitle,blogItem)VALUES('miaoqiang','http://testAddData.com','springboot之batch','springboot');
            SET n=n+1;
        IF n=100000 THEN
            LEAVE loopname;
        END IF;
        END LOOP loopname;
END;
CALL my_insert();