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 ;