title: if i use LIMIT on a mysql query, should the result set be equal to the limit?
body: <p>for example will <code>select * from table limit 0,5</code> <br>return at most 5 rows or <br> must it find exactly 5 and if the row_count doesnt equal 5, it returns an empty result set?</p>
  
  <p><br> what if the query was <code>select * from table limit 5</code>?</p>