title: How to schedule a MySQL Event on every XX:50 Seconds?
body: <p>I Have a MySQL table with field name result. I want to use a event to execute <strong>on every XX:50</strong> seconds and update the value of field by a random number.</p>
  
  <p>Need help regarding the syntax for every XX:50 seconds.</p>
  
  <p>I have tried this query.</p>
  
  <pre><code>CREATE EVENT `testEvent` 
  ON  SCHEDULE EVERY 50 SECOND 
  DO BEGIN
  
  SET @A := (SELECT MAX(`id`) FROM `table`);
  
  UPDATE `table` SET `field` = (RAND()*18) WHERE `id` = @A;   
  
  END
  </code></pre>
  
  <p>using this query first update is done on 00:00:50 then next update will be done on 00:01:40, 00:02:30 and so on.</p>
  
  <p>but i want to execute it on 00:00:50, 00:01:50, 00:02:50 and so on..</p>