在不同的表MysQL查询中删除Entrys(Delete Entrys in different Tables MysQL Query)

 我想弄清楚，如何用INNER JOIN删除数据库中的一些条目。 
 
 我有2个不同的表，USER和BLOGS 
 
 我正在尝试删除BLOGS中的所有条目，当条目属于用户时，该条目不存在。 因此，在USER表中，列出了具有唯一ID的所有用户。 表BLOGS中也有相同的ID。 
 
 像这样的查询可以工作，但我想这甚至不是一个正确的mysql查询： 
 
delete from BLOGS where `id` does not exist in USER;
 
 我知道，命令“不​​存在”并不真正起作用。 
 
 任何想法？ 提前致谢。 

I'm trying to figure out, how to delete some entries in the database with INNER JOIN.
 
I have 2 different Tables, USER and BLOGS
 
I'm trying to delete all entries in BLOGS, when the entry belongs to a user, which does not exist. So in USER table there are all users listed with a unique ID. This same ID also is in table BLOGS.
 
A Query like this would work, but I guess this is not even a correct mysql query:
 
delete from BLOGS where `id` does not exist in USER;
 
I know, the command "does not exist" doesn't really work.
 
Any Idea? Thanks in advance.

原文：https://stackoverflow.com/questions/16983248