title: Mysql - delete from multiple tables with one query
body: <p>I have 4 tables that stores different information about a user in each.  Each table has a field with user_id to identify which row belongs to which user.  If I want to delete the user is this the best way to delete that users information from multiple tables? My objective is to do it in one query.</p>
  
  <p>Query:</p>
  
  <pre><code>"DELETE FROM table1 WHERE user_id='$user_id';
  DELETE FROM table2 WHERE user_id='$user_id';
  DELETE FROM table3 WHERE user_id='$user_id';
  DELETE FROM table4 WHERE user_id='$user_id';";
  </code></pre>