Skip to content

Instantly share code, notes, and snippets.

@delphinus
Created September 11, 2012 10:01
Show Gist options
  • Select an option

  • Save delphinus/3697354 to your computer and use it in GitHub Desktop.

Select an option

Save delphinus/3697354 to your computer and use it in GitHub Desktop.
get count of rows in MySQL
SELECT SQL_CALC_FOUND_ROWS id, name FROM address LIMIT 10, 30;
SELECT FOUND_ROWS();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment