himinseop/FOUND_ROWS.sql

Last active February 22, 2017 02:04

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/himinseop/6fa44a9156680fd2596afd43fe7e04cd.js"></script>
Save himinseop/6fa44a9156680fd2596afd43fe7e04cd to your computer and use it in GitHub Desktop.

Download ZIP

Raw

FOUND_ROWS.sql

	SELECT SQL_CALC_FOUND_ROWS * FROM article limit 10;

	SELECT FOUND_ROWS();

Author

himinseop commented Jan 20, 2017

ref : https://blog.asamaru.net/2015/09/11/using-sql-calc-found-rows-and-found-rows-with-mysql/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment