title: Mysql Recurring Events
body: <p>I am trying to update my table after every 24 hours. I have tried the following examples but event triggers only one time </p>
  
  <pre><code>CREATE EVENT mydb.time_sync
  ON SCHEDULE
    EVERY '1 0' DAY_HOUR       
  STARTS '2013-01-16 16:53:00' 
  DO
    UPDATE mydb.mytable SET is_time_sync = 0;
  </code></pre>
  
  <p>I tried another but it again repeats only one time</p>
  
  <pre><code>CREATE EVENT mydb.time_sync2
  ON SCHEDULE
    EVERY 24 DAY_HOUR       
  DO
    UPDATE mydb.mytable SET is_time_sync = 0;
  </code></pre>
  
  <p>this failed too occur just one time</p>
  
  <pre><code>CREATE EVENT mydb.time_sync3
  ON SCHEDULE EVERY '1' DAY
  STARTS '2013-01-16 16:53:00' 
  DO
      UPDATE mydb.mytable SET is_time_sync = 0;
  </code></pre>
  
  <p>I am using MySQL 5.5 and event scheduler is ON</p>