mysql 批量插入数据脚本

DELIMITER $$

USE `test`$$

DROP PROCEDURE IF EXISTS `generate_app_centre`$$

CREATE DEFINER=`root`@`%` PROCEDURE `generate_app_centre`()
BEGIN 
        DECLARE i INT;
        SET @UUID='';
        SET i=2000000;
       SET AUTOCOMMIT=0;     
        WHILE i<>3000000 DO
                SET @UUID=REPLACE(UUID(),'-','');
                INSERT INTO `crm-app`.app_centre (id, title, icon_url, link, group_type, jump_type, fixed_page_code, sequence, delete_flag, create_time, update_time, create_by, update_by, create_by_name, update_by_name, note, remark, cam_code, cam_name, org_id, org_code, org_name, org_parent_ids, font_color, online_status) VALUES 
                (@UUID, '测试特权', 'https://img.allpyra.com/png/2019/04/20/ee5987cb767941eaa16675353d67b093.png', '', 'my_server', 'fixed_page', 'page_privilege', 1, FALSE, '2019-04-20 14:35:08', '2019-04-23 09:58:33', 'c2626a537bfb4690be50dc5dff6d4697', 'c2626a537bfb4690be50dc5dff6d4697', 'song1', 'song1', NULL, '', '', 'SCRM', '473fbf282aac45919c8812e93c57df5c', 'sanzhi1', '三只松鼠1号店', '1.76c58ec964d84e85bd07b17e151287be', '#323232', 'down');
                SET i=i+1;
                IF i%10000=0 THEN 
                COMMIT;
                END IF;
        END WHILE;
        COMMIT;
        SET AUTOCOMMIT=1;     
END$$

DELIMITER ;