Is there any way to not sending the result of a user variable assignment to
the client?

I.e. Suppress the result of;

SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1

...since I only use @temp in my next statement to produce the actual result.


Also, is there a equivalence to the MSSQL statement;

SET NOCOUNT ON

...in MySQL, which suppresses the "rows affected" messages?

Thanks!

Jens Pettersson


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to