How to return the total number of queries by mysql

Editor to share with you how mysql returns the total number of queries. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql returns the total number of queries: first open the terminal, then add [SQL_CALC_FOUND_ROWS] to the SELECT statement, and finally fetch the total number of records after the execution of [select SQL_CALC_FOUND_ROWS].

Mysql returns the total number of queries:

Enter the statement:

Select * from auth_userSELECT FOUND_ROWS () / / returns the total number of query records select sql_calc_found_rows col_name from table_name limit 5, record 3, select found_rows ()

Add decorated SQL_CALC_FOUND_ROWS to the SELECT statement

After adding SQL_CALC_FOUND_ROWS, SELECT FOUND_ROWS () returns the total number of records that meet the criteria, even if you use limit NJ m. In this way, after you have executed the select SQL_CALC_FOUND_ROWS, you can fetch the total number of records.

After reading this article, I believe you have a certain understanding of how mysql returns the total number of queries. Want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!