SQL_CALC_FOUND_ROWS deprecated as of MySQL 8.0.17

Noticed that SQL_CALC_FOUND_ROWS is still used in queries to display form entries.
Found information about deprecated functionality in
dev.mysql.com /doc /refman /8.0/en/information-functions.html
Something to consider for future releases?
Rgrds, Cees van Dongen

The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are deprecated as of MySQL 8.0.17; expect them to be removed in a future version of MySQL. As a replacement, considering executing your query with LIMIT , and then a second query with [ COUNT(*) ]

I’ll pass that along to the product development team. Thank you.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.