Mysql: delete rows in two tables with foreign keys
<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>