Mysql method for obtaining the total number of rows of group by records, mysqlgroup
Mysql can obtain the total number of record groups in a field within the group by statement, but cannot count the number of records in the group.
Mysql SQL _CALC_FOUND_ROWS writes the following statements in many paging programs:
The Code is as follows:
Select count (*) from 'table' WHERE ......;
Total number of records that meet the criteria
The Code is as follows:
SELECT * FROM 'table' WHERE... limit M, N;
To query the data to be displayed on the page, you can change the statement:
The Code is 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 the SQL _CALC_FOUND_ROWS and FOUND_ROWS () functions provided by mysql.
The Code is 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 each other) GROUPBY t3.id LIMIT 10, 20 SELECT FOUND_ROWS () as count;
Use the preceding two statements to complete the total number of records that meet the requirements of group.
Appendix:
Simple use of group:
The Code is as follows:
'Select column_id, count (*) as count FROM my_table group by column_id ';
From: http://www.111cn.net/database/mysql/50323.htm
How to obtain the row number of the current record in mysql
In fact, if your table contains a self-increasing field, if from 1, Which row is the ID?
How to count the number of records after the mysql group, count after gourp
Select count (*) from
(SELECT count (*) FROM table name WHERE condition group by id);