Re: Problem with INTO OUTFILE

2004-05-18 Thread Jiri Matejka
I had similar problem on W2000 - the solution is not to use ... field terminated by ';' ... but ...fields terminated by '\t'. I don't know why semicolon causes this problem, but If I use \t then it works. Jirka Matejka - Original Message - From: "Jochen Kaechelin" <[EMAIL PROTECTED]>

Re: Problem with INTO OUTFILE

2004-05-18 Thread Victoria Reznichenko
Jochen Kaechelin <[EMAIL PROTECTED]> wrote: > Can somebody tell me what's wrong with this query: > > $sql="SELECT * INTO OUTFILE 'infoanforderung/$nameliste' FIELDS > TERMINATED BY ';' LINES TERMINATED BY '\n' FROM net_contact WHERE > nachname='Erbel'"; > > I get no results! Without "INTO OUTFI