炼气大圆满修士的博客

DROP TABLE IF EXISTS `mgt_emp_resign_order_copy`;CREATE TABLE `mgt_emp_resign_order_copy` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `order_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编号', `.

-- 批量更新有订单的数据-- 批量刷商机编码UPDATE IGNORE vip.mgt_emp_resign_order_copy o1 SET o1.lead_code = ( SELECT o2.lead_code FROM crm.crm_lead_order_rel o2 WHERE o1.order_code = o2.order_code ) WHERE EXISTS ( SELECT o3.id FROM crm.crm_lead_order_rel o3 WHERE o1.orde.

INSERT IGNORE INTO crm.crm_customer_public ( `cust_code`, `user_code`, `user_name`, `store_code`, `store_name`, `type`, `fell_time` ) SELECT l.cust_code, d.user_code, d.chinese_name, d.dept_code, d.dept_name, 1, "2020-09-04 12:12:12" FROM crm.crm_customer.

=CONCATENATE("INSERT INTO `crm`.`crm_enterprise_contract_copy`(`enterprise_name`, `start_time`, `end_time`,`create_time`,`update_time`) VALUES ('",B3,"','",C3,"','",D3,"','2020-09-25,','2020-09-25');")

代码防止通过唯一编码在数据库获取是否存在通过sql防止insert into table (xxx) select xxx from dual where not exists(select cust_tel from crm_customer_detail_extra where cust_tel=#{custTel,jdbcType=VARCHAR})3.注解设置防止重复提交...