MySQL 删除 "inactive"行

Question

我有 2 个表:

用户

编号 |姓名 |邮件 |通过 |盐

条目

编号 | uid |标题 |文字 |时间戳

现在我想删除所有带有 uid 的 entries 行，它在 user 表中不存在(删除用户)

我认为这可能会像这样工作:

DELETE entries FROM user, entries WHERE [What comes here? I don't know :(]

Answer 1

DELETE FROM entries WHERE uid NOT IN (SELECT DISTINCT id FROM user);