SQL_CALC_FOUND_ROWS и FOUND_ROWS() Устарели
Primary tabs
Forums:
SQL_CALC_FOUND_ROWS и FOUND_ROWS() объявлены устаревшими в MySQL версии 8, теперь вместо:
SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100; SELECT FOUND_ROWS();
Следует писать:
SELECT * FROM tbl_name WHERE id > 100; SELECT COUNT(*) FROM tbl_name WHERE id > 100;
- Log in to post comments
- 1280 reads