MYSQL 批量插入

DROP PROCEDURE IF EXISTS per2;
create procedure per2()
begin

declare num int;
declare theme_id int;
declare Category_id int;
declare url_ varchar(100) default 'http://cdn1.yunovo.cn/2018113016460800002/1 _';

set num=1;
set theme_id=1401;
set Category_id=1101;

while num < 107 do
	
	INSERT INTO `clw`.`ocp_theme_info` (`id`, `oneCategory_code`, `category_code`, `name`, `desc`, `theme_pic`, `wallpaper_pic`, `theme_author`, `theme_tag_id`, `device_type`, `skin_version`, `skin_frame_vercode`, `theme_series`, `resolution`, `status`, `belong_org`, `org_code`, `create_by`, `create_datetime`, `update_by`, `update_datetime`) VALUES 
	(theme_id, Category_id, '-1', CONCAT('终端测试类1_',theme_id), 'I am Iron Man！纪念永远的钢铁侠！', CONCAT(url_,num,'_.jpg'), 'http://cdn1.yunovo.cn/doi_common/2019-07-31/2019073117105300000/bg.png', '张强', '', '1', '1.5', '1', '1', '1024x600', '1', '-1', '', 'admin', '2019-07-31 11:40:57', 'admin', '2019-08-19 16:38:36');

	INSERT INTO `clw`.`ocp_theme_res` ( `source_type`, `source_id`, `res_url`, `res_size`, `res_md5`, `create_by`, `create_datetime`, `update_by`, `update_datetime`) VALUES ( '2', theme_id, 'http://cdn1.yunovo.cn/doi_common/2019-07-31/2019073111375600001/1.jpg', '-1', '-1', 'admin', '2019-08-12 20:29:13', 'admin', '2019-08-12 20:29:13');
	INSERT INTO `clw`.`ocp_theme_res` ( `source_type`, `source_id`, `res_url`, `res_size`, `res_md5`, `create_by`, `create_datetime`, `update_by`, `update_datetime`) VALUES ( '1', theme_id, 'http://cdn1.yunovo.cn/doi_common/2019-08-12/2019081220264400037/2019081220264400037.yov', '831621', '01811837f522ae5671a196d40f73afa4', 'admin', '2019-08-12 20:29:13', 'admin', '2019-08-12 20:29:13');
	set num=num+1;
	set theme_id=theme_id+1;

end while;
end;

call per2();