title: Why is "LIMIT 0" even allowed in MySQL SELECT statements?
body: <p><code>Limit 0, 1000</code> returns the first 1,000 results, but <code>LIMIT 0</code> returns 0 results.</p>
  
  <p>That's not very intuitive imho. For example, dumb old me thought that removing the 1000 would remove the upper limit to the SELECT query, thus returning all of the results.</p>
  
  <p>Why would anybody even want to query MySQL for 0 results?</p>