title: MySQL - Using COUNT and LIMIT functions together
body: <p>I have a table 'Labs' with 14 entries.</p>
  
  <p>The query <code>SELECT COUNT(Labs.sid) FROM Labs LIMIT 0, 18446744073709551615</code> returns "14".</p>
  
  <p>However the query <code>SELECT COUNT(Labs.sid) FROM Labs LIMIT 1, 18446744073709551615</code> returns "0" (not 13 as I would expect). In fact, "0" is still returned when I set the LIMIT row offset value 2, 3, 4, etc.</p>
  
  <p>Why is this? Is there a way to determine the number of rows after a specified offset using just mysql?</p>
  
  <p>FWIW I'm using MySQL 5.5.9 and the InnoDB database engine.</p>