title: why does SELECT statement doesn't get executed by EVENT scheduler in mysql?
body: <p>i am learning to create <strong>event</strong> in mysql, i tried sucessfully insert, update and delete commands.
  but with SELECT statement, it doesn't show the output.</p>
  
  <pre><code>mysql&gt; CREATE EVENT e_totals ON SCHEDULE AT '2013-06-04 23:59:00' DO INSERT INTO test.totals VALUES (NOW());
  </code></pre>
  
  <p>the above event works fine.
  but the event below isn't not working...</p>
  
  <pre><code>mysql&gt; CREATE EVENT e_totals ON SCHEDULE EVERY 30 seconds DO SELECT * FROM test.totals;
  </code></pre>
  
  <p>i've set all the global parameters and also enabled the event.
  what i am doing wrong????</p>