title: How and when to use SLEEP() correctly in MySQL?
body: <p>In relation to <a href="https://stackoverflow.com/questions/4284162/calling-stored-procedure-sequentially-from-sql-file-and-php-fails-differently">my other question</a> today I am wondering how to use <a href="http://dev.mysql.com/doc/refman/5.6/en/miscellaneous-functions.html#function_sleep" rel="noreferrer">MySQL's <code>SLEEP(duration)</code></a> correctly.</p>
  
  <p>From what I gathered reading MySQL Dev forums and very vague description in MySQL Docs I can't use it this way:</p>
  
  <pre><code>SELECT ...
  SLEEP(1); /* wait for a second before another SELECT */
  SELECT ...
  </code></pre>
  
  <p>So what is it good for then?</p>