title: MySQL multiple-table delete syntax
body: <p>I try to do 2 delete queries in one. For example:</p>
  
  <pre><code>DELETE FROM `comments` WHERE `article_id` = 4;
  DELETE FROM `aricles` WHERE `id` = 4;
  </code></pre>
  
  <p>I tried using a single query:</p>
  
  <pre><code>DELETE `articles`, `comments` 
  FROM `articles` INNER JOIN `comments` 
  WHERE `comments`.`article_id` = `articles`.`id` AND `articles`.`id` = 4
  </code></pre>
  
  <p>That works well if in table <code>comments</code> exist records with <code>article_id</code> 4, but doesn't remove <code>articles</code> records with <code>articles</code>.<code>id</code> = 4, if in <code>comments</code> records with <code>article_id</code> = 4 not found. Is there any way to do that?</p>