MySQL翻页查询时一次查询出总条数,减少查询次数,提高查询速度

    xiaoxiao2022-07-03  103

    /*一次查询出总条数*/ SELECT SQL_CALC_FOUND_ROWS * FROM `system_notice`; SELECT FOUND_ROWS() AS pcount

     

    最新回复(0)