Mysql不存在就插入，存在则不操作

不存在就插入，存在则不操作（必须有唯一键）
使用insert ignore语句，例如插入数据：
insert ignore into tablename (last_name,first_name) values ('bar','foo');
表字段(last_name,first_name)为联合唯一键，如果表中已经存在last_name='bar’且first_name='foo’的数据，就不会插入，如果没有就会插入一条新数据。

使用INSERT INTO ... SELECT ...，可以达到同样的效果

插入订单表数据，部分参数传入，部分参数select from 套餐表

mysql 套餐表

CREATE TABLE `plan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` char(1) COLLATE utf8mb4_bin NOT NULL COMMENT '类型|plan_type|1:默认套餐,2:收费套餐',
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '套餐名称',
  `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '价格',
  `expiry_months` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '期限月份数',
  `view_resume_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '查看简历份数/天',
  `release_recruit_count` int(11) NOT NULL DEFAULT '0' COMMENT '发布招聘信息次数',
  `refresh_recruit_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '刷新招聘信息次数',
  `sort` int(11) unsigned DEFAULT '1' COMMENT '排序',
  `invitee_company_size` double(1,0) unsigned DEFAULT '1' COMMENT '邀请公司入驻数量,赠送此套餐',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` varchar(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除标记',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='企业服务套餐';

mysql套餐订单表

CREATE TABLE `plan_order` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pay_type` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '2' COMMENT '支付类型(pay_type)|1:支付宝,2:微信',
  `trade_no` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '交易单号',
  `pay_order_no` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '支付平台的交易单号',
  `company_id` bigint(20) unsigned NOT NULL COMMENT '企业/公司ID',
  `invitee_company_id` bigint(20) DEFAULT NULL COMMENT '被邀请公司ID',
  `plan_id` bigint(20) unsigned NOT NULL COMMENT '服务套餐ID',
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '套餐名称',
  `price` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '价格',
  `expiry_months` int(10) unsigned NOT NULL COMMENT '期限月份数',
  `due_date` datetime NOT NULL COMMENT '到期日期',
  `view_resume_count` int(11) unsigned NOT NULL COMMENT '查看简历次数',
  `view_resume_remainder` int(11) unsigned NOT NULL COMMENT '查看简历剩余次数(已废弃)',
  `release_recruit_count` int(11) unsigned NOT NULL COMMENT '发布招聘信息次数',
  `release_recruit_remainder` int(11) unsigned NOT NULL COMMENT '发布招聘信息剩余次数',
  `refresh_recruit_count` int(11) unsigned NOT NULL COMMENT '刷新招聘信息次数',
  `refresh_recruit_remainder` int(11) unsigned NOT NULL COMMENT '刷新招聘信息剩余次数',
  `type` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '2' COMMENT '订单类型 order_type 1:购买,2:赠送',
  `status` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '2' COMMENT '订单状态 order_status 1:未支付,2:可使用, 3:作废',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` varchar(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除标记',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='toB服务套餐订单';

mybatis 传入参数，companyId，planId，type，status

	<insert id="insertSelectByPlanIdAndTypeAndStatus" useGeneratedKeys="true" keyProperty="id">
		INSERT INTO plan_order (company_id, plan_id,type, status, name, price, expiry_months, due_date, view_resume_count, view_resume_remainder, release_recruit_count, release_recruit_remainder, refresh_recruit_count, refresh_recruit_remainder, create_date)
			SELECT #{companyId} as company_id,#{planId} as plan_id,#{type} as type,#{status} as status, name, price, expiry_months, date_add(NOW(), interval expiry_months MONTH) as due_date,view_resume_count,view_resume_count,release_recruit_count,release_recruit_count,refresh_recruit_count,refresh_recruit_count,now() as create_date FROM plan
				WHERE
					 id = #{planId} AND del_flag = '0'
	</insert>

顺便来个insert into ... select from 批量插入 例子：

	<insert id="insertBatch" parameterType="list" useGeneratedKeys="false">
		 INSERT INTO shopcart(user_id, spu_id, title, img, sku_id, price, sku_name, buy_count, istatus, create_date)
		<foreach collection="list" item="item" open="" separator="union all">
			SELECT * FROM (SELECT #{item.userId} AS user_id,b.id AS spu_id,b.title,b.img,c.id AS sku_id,c.price,c.name AS sku_name,#{item.buyCount} AS buy_count,#{item.istatus} AS istatus,now() AS create_date FROM spu AS b LEFT JOIN service_goods_sku AS c ON b.id=c.spu_id WHERE c.id=#{item.skuId} and c.del_flag='0') AS tb
		</foreach>
	</insert>