How does mysql return the total number of queries

Mysql returns the total number of queries: first open the terminal; then add modification [SQL_CALC_FOUND_ROWS] to the SELECT statement; finally execute [select SQL_CALC_FOUND_ROWS], and then take the total number of records. Enter statement: select * from auth_user SELECT FOUND_ROWS() //Returns the total number of query records select sql_calc_found_rows col_name from table_name limit 5,3; select found_rows() Add modification SQL_CALC_FOUND_ROWS After adding SQL_CALC_FOUND_ROWS to the SELECT statement, even if you use limit n,m, SELECT FOUND_ROWS() will still return the total number of records satisfying the condition. In this way, after you execute select SQL_CALC_FOUND_ROWS, just fetch the total number of records. More related free learning recommendations: mysql tutorial (video) The above is the detailed content of how mysql returns the total number of queries. For more information, please pay attention to 1024programmer. com Other related articles!