Skip navigation links

MySQL Forums :: Microsoft SQL Server :: MySQL 5.0 equivalent of SQL Server SET NOCOUNT ON


Advanced Search

MySQL 5.0 equivalent of SQL Server SET NOCOUNT ON
Posted by: Andrew Wood ()
Date: February 25, 2006 12:27PM

Hi,

I'm migrating a bunch of stored procedures from SQL Server 2000 to MySQL 5.0. I need to find a MySQL equivalent to SQL Server's

SET NOCOUNT ON

This disables the verbose feedback in queries (e.g. '213 rows affected') - necessary to avoid the problem of being unable to process a recordset due to multiple select feedbacks when procedures running more than one select statement are run.

Any help much appreciated.

Cheers
Andy

Options: ReplyQuote


Subject Written By Posted
MySQL 5.0 equivalent of SQL Server SET NOCOUNT ON Andrew Wood 02/25/2006 12:27PM


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.