mysql语句

清泉柒墨 / 2023-07-25 / 原文

mysql判断关联是否存在

SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE table2.id = table1.id)