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]