title: mysql query delete multiple tables with single query when the foreign key relationship
body: <p>I have create blog system. In this blog i have created three tables.</p>
  
  <p>Table 1: article</p>
  
  <pre><code>+----------------+-----------+-------+-------------+
  | article_id(PK) | name      | description         |
  +----------------+-----------+-------+-------------+
  | 1              | article-1 | lorem ipsum       |
  | 2              | article-2 | lorem ipsum       |
  +----------------+-----------+-------+-------------+
  </code></pre>
  
  <p>Table 2: article_hook</p>
  
  <pre><code>+---------------------------+---------+-----------+
  | article_hook_id(PK, auto) | hook_id | hook_type |
  +---------------------------+---------+-----------+
  | 1                         | 1       | article   |
  | 2                         | 1       | tag       |
  +---------------------------+---------+-----------+
  </code></pre>
  
  <p>Here I have created foreign key relationship. and i want delete the article create delete query</p>
  
  <pre><code>DELETE FROM article WHERE article_id = 1 LIMIT 1
  </code></pre>
  
  <p>It's deleted the record successfully. But it delete all the records in article_hook table where hook_id = 1. But I need to delete only one record from article_hook table when I pass Hook_id=1 and hook_type='article'.</p>