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

multiple sqls

User, date Message
Written by BubikolRamios
3 years ago
Category: General
327 posts since Thu, 14 Jan 10


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. */

Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
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 ?
Written by ansgar
3 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Thanks. Figured it out.
 

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