mysql 查询存在表A不存在与表B的记录

SELECT * FROM A WHERE id NOT IN ( SELECT id FROM B); 或者 SELECT * FROM A WHERE NOT EXISTS ( SELECT 1 FROM B WHERE B.id = A.id ); 或者 SELECT A.* FROM A LEFT JOIN B ON (A.id = B.id) WHERE b.id IS NULL