MySQL Forums
Forum List  »  Stored Procedures

how to set the execution for specified number of rows in stored procedures
Posted by: ujvala ujvala
Date: November 02, 2005 01:08AM

hi everyone,

"i want to stop the processing of a query in a stored procedure after a specified number of rows." how can i do this in mysql? is there any system variable such as ROWCOUNT as in sql server? i had referred mysql manuals and came across the mysql_fetch_row that can be used in C API. but that was not my solution.

anyone can come up with solution!!

thanx in advance

UJVALA

Options: ReplyQuote


Subject
Views
Written By
Posted
how to set the execution for specified number of rows in stored procedures
2839
November 02, 2005 01:08AM


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.