MySQL Forums
Forum List  »  General

Getting "maxAvailableRows" with a query?
Posted by: Charl Gerber
Date: February 21, 2005 01:44AM

Hi,

I have a query in the format of:

SELECT * FROM users LIMIT 50

Is it possible to somehow get the number of rows that would have been returned if it was not for the LIMIT clause without doing a seperate "SELECT COUNT(*) FROM users" ?

Ie, I want to know the total number of rows plus my 50 results with 1 call to the database, not 2.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Getting "maxAvailableRows" with a query?
February 21, 2005 01:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.