distal-attribute
distal-attribute
distal-attribute
distal-attribute

multiple sqls

BubikolRamios posted 3 years ago in General

select SQL_CALC_FOUND_ROWS * from debug
limit 0,5;
select SQL_CALC_FOUND_ROWS * from debug;



it shows me 5 rows in resultset. Shoudn't it show me 26 rows ?

select SQL_CALC_FOUND_ROWS * from debug
limit 0,5;
select SQL_CALC_FOUND_ROWS * from debug;
/* 0 rows affected, 31 rows found. Duration for 2 queries: 0,062 sec. */

BubikolRamios posted 3 years ago
Ahh, I see it now. Multiple tabs in resultset windov (-:

oftopic: There is a prob with mysql.If anyone can exlain that:

select SQL_CALC_FOUND_ROWS * from debug
limit 0,5;
select FOUND_ROWS();



and in second resultab I get 26 instead of 5 ?
ansgar posted 3 years ago
SQL_CALC_FOUND_ROWS causes FOUND_ROWS() to return the overall number or rows in your debug table, not the 5 to which you have limited your first query.
BubikolRamios posted 3 years ago
Thanks. Figured it out.

Please login to leave a reply, or register at first.