MySQL Forums
Forum List  »  Stored Procedures

Re: how to find the number of rows in a select statement in a stored procedure
Posted by: Roland Bouman
Date: October 11, 2005 06:21PM

Yes, the docs do indicate that. But, its not a real problem, is it? I mean, you just wanted to test if it returns zero rows.

I mean this: after you execute the query, FOUND_ROWS() is either less than the LIMIT, in wich case it yielded FOUND_ROWS() rows, or FOUND_ROWS() is more then (or equal to) LIMIT, in wich case it yielded LIMIT rows.



Edited 1 time(s). Last edit at 10/12/2005 01:13AM by Roland Bouman.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to find the number of rows in a select statement in a stored procedure
3841
October 11, 2005 06:21PM


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.