Re: Count all rows if limit by?

Thanks a lot, Jigal and Egor - just what i searched for! Sincerely Victor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Count all rows if limit by?

Hi all! Is there a simple way to get the total number of rows a result _should_ have had if no where-clause where present? Without doing a second query? Sincerely Victor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Count all rows if limit by?

From: Victor Spång Arthursson [EMAIL PROTECTED] Is there a simple way to get the total number of rows a result _should_ have had if no where-clause where present? Without doing a second query? Example from http://www.mysql.com/doc/en/Information_functions.html : mysql SELECT

Re: Count all rows if limit by?

Victor Sp?ng Arthursson [EMAIL PROTECTED] wrote: Hi all! Is there a simple way to get the total number of rows a result _should_ have had if no where-clause where present? Without doing a second query? If you want to get total number of rows in the table (without WHERE and without