multiple sqls

User, date Message
Written by BubikolRamios
1 year ago
Category: General
273 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
1 year ago
273 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
1 year ago
3949 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
1 year ago
273 posts since Thu, 14 Jan 10 		Thanks. Figured it out.
 

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