List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 10 1999 9:36pm
Subject:Re: LOAD DATA INFILE
View as plain text  
On Fri, 1999-09-10 02:49:14 -0000, Todd M Greanier wrote:
> I have tried this on both Windows and Linux....same result. It is
> acting like the the line termination is screwy, but I cannot figure
> it out.

From your description it really looks like a problem with line
termination.

> LOAD DATA INFILE '/Batting.cvs/ INTO TABLE Baseball FIELDS
> TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';

Did you already try adding
   LINES TERMINATED BY '\r\n'
or the like?

Best you look with a good editor (or hex dump), what the line endings
of your file actually are.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
LOAD DATA INFILETodd M Greanier10 Sep
  • LOAD DATA INFILEJani Tolonen10 Sep
  • Re: LOAD DATA INFILEMartin Ramsch10 Sep