Re: variables in select into outfile

2003-08-27 Thread Victoria Reznichenko
"Thompson, Jordan" <[EMAIL PROTECTED]> wrote: > I wan to use a variable for the outfile file name in a select into clause. I am > doing something like: > > set @fileName="/tmp/result.text" > SELECT col1, col2 INTO OUTFILE @fileName > FIELDS TERMINATED BY ',' > FROM test_table; > > the interprete

variables in select into outfile

2003-08-26 Thread Thompson, Jordan
I wan to use a variable for the outfile file name in a select into clause. I am doing something like: set @fileName="/tmp/result.text" SELECT col1, col2 INTO OUTFILE @fileName FIELDS TERMINATED BY ',' FROM test_table; the interpreter dies at the @fileName... if I exchange @filename with "/tmp/re