title: Create Trigger to delete rows that are >90 days old
body: <p>Trying to create a trigger that will delete any record that is 90 days old. I used a trigger statement from stackoverflow that I have found and changed the statement a bit, but in my MySQL Workbench, I am getting a syntax error. I cannot seem to figure what is wrong. </p>
  
  <p>Below is my query:</p>
  
  <pre><code>create trigger user_connections_dump after insert on user_connections 
  for each row
  begin
     delete from connection_time where Date('2014-06-09') &gt; Date('now','-90 days')
  end;
  </code></pre>