title: How to use multiple sql statements in a mysql event?
body: <p>These are the statements</p>
  
  <pre><code>INSERT INTO toolate (name,type,date) 
  SELECT  name, type ,date 
  FROM homework 
  WHERE date &lt; CURRENT_DATE()
  </code></pre>
  
  <p>and</p>
  
  <pre><code>DELETE FROM homework WHERE date &lt; CURRENT_DATE()
  </code></pre>
  
  <p>I need to combine these two so that my event will work in a proper order.
  Firstly the INSERT statement then the DELETE one.</p>
  
  <p>That way I can still see homework that's past date while having a clean homework table and it needs to happen automatically thus why I'm using events. Of course I will welcome a different solution.</p>