title: Performing Multiple Queries in MySQL Event
body: <p>I am trying to alter my event in MySQL. I want it to perform the first INSERT then delete all the data from a table. When I try to alter the event with this code: </p>
  
  <pre><code>ALTER event transfer_to_population_hist do INSERT INTO population_hist
              (
                          location_id,
                          count,
                          dtm
              )
  SELECT DISTINCT(location_id),
                  Max(count),
                  dtm
  FROM            current_population
  GROUP BY        current_population.location_id;DELETE
  FROM   current_population; 
  </code></pre>
  
  <p>it performs 2 queries.  One where it alters the event only including the insert statement and then another query where it deletes all the data from the table. </p>
  
  <p>I want it to also delete the data during the event.</p>