mysql - 使用连接从两个表中删除

Question

我有一个问题:

SELECT *
FROM `phpbb_posts` AS a
JOIN phpbb_posts_text AS b ON a.post_id = b.post_id
WHERE a.poster_id =5413

它给了我 X 行数，我想要一个将删除所有这些行的查询(我不需要首先选择这只是 JOIN 的一个示例。

有什么帮助吗？

Answer 1

就这么简单。

DELETE a, b    
FROM `phpbb_posts` AS a
JOIN phpbb_posts_text AS b ON a.post_id = b.post_id
WHERE a.poster_id =5413