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]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 18, 2004 4:30 AM Subject: Problem with INTO OUTFILE > 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 OUTFILE everything works fine! > > -- > Jochen Kaechelin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
