I didn't understand the problem very well, but maybe disabling the pager before that query where you set @temp, do the query, setting the pager to its default value and then do the "next statement to produce the actual result."
\P cat /dev/null SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1 \n SELECT .... -- Diana Soares On Tue, 2004-08-31 at 23:00, Eamon Daly wrote: > Did anyone ever follow up on this question? I'm looking for > the answer, too. > ____________________________________________________________ > Eamon Daly > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 25, 2004 9:16 AM > Subject: Suppression of result in SELECT @temp := column? > > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
