Hi!
On Aug 25, 2004, at 8:16, <[EMAIL PROTECTED]> wrote:
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.
Use DO instead of SELECT. DO is like SELECT, except that it doesn't return any results.
Also, is there a equivalence to the MSSQL statement;
SET NOCOUNT ON
...in MySQL, which suppresses the "rows affected" messages?
Not AFAIK. You can make the MySQL client less verbose (which includes suppressing the rows affected message) by starting the client with the --silent/-s option.
Cheers! --zak
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
