平成30/ 2018-10-24 06:43
mysql/ LIMIT, 総数取得
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 0, 10;
mysql> SELECT FOUND_ROWS();

( Thanks. )
http://pagerank.cocolog-nifty.com/blog/2008/03/mysqllimitsql_c_57f9.html

#key#SQL_CALC_FOUND_ROWS