title: Delete from multiple tables with common column in one query?
body: <p>Micro optimization I know, this is more because I am curious.</p>
  
  <p>I have two link tables,</p>
  
  <pre><code>blog_categories_posts =&gt; post_id, category_id  
  blog_tags_posts       =&gt; post_id, tag_id
  </code></pre>
  
  <p>I am removing all links from both tables based on the <code>post_id</code>:</p>
  
  <pre><code>DELETE FROM blog_categories_posts WHERE post_id = {$id};
  DELETE FROM blog_tags_posts WHERE post_id = {$id};
  </code></pre>
  
  <p>Anyway, I am wondering if it is possible to delete from both tables at once, and whether it would be a performance (whilst micro) hit or gain?</p>
  
  <p>I imagine if it was to work:</p>
  
  <pre><code>DELETE FROM blog_categories_posts, blog_tags_posts where post_id = {$id} 
  </code></pre>
  
  <p>or a similar syntax?</p>