Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.