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
> 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.
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