SQL_CALC_

最新推荐文章于 2022-05-12 09:23:05 发布

boyatec

最新推荐文章于 2022-05-12 09:23:05 发布

阅读量176

点赞数

分类专栏： MYSQL 文章标签： SQL MySQL Cache

本文链接：https://blog.csdn.net/boyatec/article/details/83679353

版权

MYSQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SQL_CALC_FOUND_ROWS Explanation 写道

SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause. The number of rows can then be retrieved with SELECT FOUND_ROWS().

mysql select syntax 写道

SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]

在做select查询时我们可以使用SQL_CALC_FOUND_ROWS,在查询后使用FOUND_ROWS()得到select的行数！

但是selec count(*) from tablename where condition同样可以得到结果行数。为什么要用SQL_CALC_FOUND_ROWS了？