php - 这个查询有什么问题

Question

$deleteUser = $_POST['userId'];

$query =    "DELETE FROM users AS USERS
           LEFT JOIN posts AS POSTS
           ON USERS.id = POSTS.postAuthor
           WHERE USERS.id = '$deleteUser' AND POSTS.postAuthor = '$deleteUser'";

我正在尝试删除该用户以及他们可能创建的任何帖子。我错过了什么？

Answer 1

指定执行DELETE的表或别名

DELETE USERS FROM users AS USERS
       LEFT JOIN posts AS POSTS
       ON USERS.id = POSTS.postAuthor
WHERE USERS.id = '$deleteUser' AND POSTS.postAuthor = '$deleteUser'