插入记录从表B表A只，如果他们不缴费表A

Question

我有两个表。表A和表B（MySQL的）

Table-A has id,value,name.. and 
Table-B has id,name,email,address.. 

我想从表中插入“身份证” B中表A“价值”只有当“ID”（表B）不存在表A as'Value”

所以我可以用这个

INSERT INTO `TableA`(`value`, `name`) 
SELECT id,name FROM TableB 
WHERE TableB.id NOT IN TableA.value 

Answer 1

您需要沿线使用代码以下：

WHERE NOT EXISTS (select * from TableA where TableA.value = TableB.id) 

Answer 2

您可以使用此解决方案：

INSERT INTO TableA (value, name) 
SELECT b.id, b.name 
FROM TableB b 
LEFT JOIN TableA a ON b.id = a.value 
WHERE a.id IS NULL