title: Create MySQL event and run first day of the year
body: <p>I had a problem on MySQL event. I want this event run every first day of the year. Currently my event will run on every month. Here is my event script.</p>
  
  <pre><code>DELIMITER $$
  CREATE EVENT create_ledger
  ON SCHEDULE EVERY '1' MONTH
  STARTS '2016-05-20 11:33:01'
   DO 
    BEGIN
      insert into ledger SET ledger_year= YEAR(CURDATE());
    END$$
  DELIMITER ;
  </code></pre>
  
  <p>hope someone can help. TQVM</p>