title: Mysql: delete rows in two tables with foreign keys
body: <p>I have two tables with data.
  I want to delete rows in both tables.
  But I have foreign keys between them.
  How can I do this?</p>
  
  <pre><code> departure
       id    departure_date
        1        2016-09-29
        2        2016-09-30
  
   departure_time
       id    departure_id (fk)
        1         1
        2         2
  </code></pre>
  
  <p>the best thing would be to have a query that gets all rows to be deleted, and deletes rows in both tables at the same time. 
  Is there a way to do this without removing constraints/FK?</p>
  
  <p>In this example, say I would like to delete all departures from date 2016-09-30</p>
  
  <p>(delete departure: id 2 and departure_time: id: 2)</p>