MySQL gets the group by interior can get the total number of record grouping statistics for a field, and cannot count the number of records grouped.
The number of rows that MySQL sql_calc_found_rows uses to get queries is written in many paging programs:
Code to copy code as follows
SELECT COUNT (*) from ' table ' WHERE ...;
Find out the total number of records that match the criteria
Code to copy code as follows
SELECT * from ' table ' WHERE ... limit m,n;
A statement that queries the data to be displayed on a page can be changed to:
Code to copy code as follows
SELECT sql_calc_found_rows * from ' table ' WHERE ... limit M, N;
SELECT found_rows ();
Because (www.111cn.net) this can be implemented with MySQL's own sql_calc_found_rows and Found_rows () functions.
Code to copy code as follows
SELECT sql_calc_found_rows t3.id, a,bunch,of,other,stuff from T1, T2, T3 where (associate T1,t2,and T3 with all other) GRO Upby t3.id LIMIT 10,20select found_rows () as Count;
Use the above two statements to complete the total number of record rows that satisfy group by.
Also attached:
A simple way to use GROUP by:
Code to copy code as follows
' SELECT column_id,count (*) as Count from My_table Group by column_id ';
From:http://www.111cn.net/database/mysql/50323.htm
MySQL gets the total number of record rows method for GROUP by