第一种
INSERT INTO clients
(client_id, client_name, client_type)
SELECT supplier_id, supplier_name, ‘advertising’
FROM suppliers
WHERE not exists (select * from clients
where clients.client_id = suppliers.supplier_id);
主要是最后这个判断是否存在,如果不存在就插入。
第二种
– 如果主键重复就更新
INSERT INTO CRM_PAK_CUST_INDEX (uuid,book_days)
VALUES (1,9) ON DUPLICATE KEY UPDATE book_days = 10;
第三种
– 如果主键重复就先删除,在插入
REPLACE INTO CRM_PAK_CUST_INDEX (uuid,book_days) VALUES(1,8);