Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to return the total number of queries by mysql

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report