title: Delete from all tables by a particular ID
body: <p>I've searched over SO, but many questions are related to truncating the tables, but I don't want to empty the tables, I need to delete from <strong>all</strong> tables, perhaps with one query instead of multiple queries.</p>
  
  <p>So far I have 34 tables in my database, I need to delete all rows that have an a particular ID when requested. For example:</p>
  
  <pre><code>DELETE FROM table1, table2 ... table33, table34
  WHERE customer_id = 4
  </code></pre>
  
  <p>How do I go ahead with a query that can do this? On another thought, all tables may not have rows that is same to the <code>customer_id</code>, so it should delete even there are no records with an ID of <code>4</code>.</p>