您正在寻找的是这个
SELECt SQL_CALC_FOUND_ROWS A.ID, A.NAME, B.ID, B.NAMEFROM table1 AJOIN table2 B ON ( A.ID = B.TABLE1_ID )WHERe cond1, cond2, ..., condNLIMIT 10SELECT FOUND_ROWS();
您正在寻找的是这个
SELECt SQL_CALC_FOUND_ROWS A.ID, A.NAME, B.ID, B.NAMEFROM table1 AJOIN table2 B ON ( A.ID = B.TABLE1_ID )WHERe cond1, cond2, ..., condNLIMIT 10SELECT FOUND_ROWS();
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
