title: MySQL Event scheduling for a specific period of time everyday with an interval of 30 minutes
body: <p>I have a MySQL trading application which runs from 10:00AM till 6:00PM everyday. It has a chart that shows trading progress every 30 minutes starting from 10:00AM.</p>
  
  <p>Can anyone please help me defining the ON SCHEDULE part of the MySQL event definition?</p>
  
  <p>Just to clarify, first reading starts at 10:00AM, 2nd 10:30, 3rd 11:00 and so till the last reading at 6:00PM.</p>