INSERT INTO customer(email,address,name,phone,phone2)
SELECT email,address,name,phone,phone2
FROM buy
WHERE NOT EXISTS(
SELECT *
FROM customer
WHERE phone = phone and (phone2 = phone or phone = phone2)
);
我想把buy的資料表中的筆數選擇email,address,name,phone,phone2 進入customer
但是若在進入customer中phone或phone2已經存在，則略過
這樣好像錯了
已邀請的邦友 {{ invite_list.length }}/5
INSERT INTO customer(email,address,name,phone,phone2)
SELECT email,address,name,phone,phone2
FROM buy A LEFT JOIN customer B on A.email=B.email AND A.address =B.address
AND (A.phon = B.phone OR A.phone=B.phone2 OR
A.phon2 = B.phone OR A.phone2=B.phone2)
WHERE B.email IS NULL ;
iThome鐵人賽
看影片追技術