An alternative method for mysql to obtain the total number of records of groupby

Mysql obtains the total number of record groups in a field within groupby, but cannot count the number of records in the group. Mysql SQL _CALC_FOUND_ROWS writes the following code in many paging programs: SELECTCOUNT (*) from 'table' WHERE ......; code for checking the total number of records that meet the condition

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 code in many paging programs: SELECT COUNT (*) from 'table' WHERE ......; code for checking the total number of records that meet the condition

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 ();

Therefore, it 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 ';