MySQL Forums
Forum List  »  Microsoft SQL Server

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL 5.0 equivalent of SQL Server SET NOCOUNT ON
Andrew Wood
February 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.