* Barbara Ferrell
> only every other line imported correctly and there was a quote around the
Seems like there is a line ending problem... windows use CRLF as line
endings in text files, but mysql expects LF only... have you tried "LINES
TERMINATED BY '\r\n';"
CR = ascii 13 = \r = return (carrig
mysql version 3.23.41 ...i am having a problem importing simple date and
text data ( 6 fields) (from access 97).
this is what i have tried:
load data local infile 'client.txt'
into table client
fields terminated by '\t';
all 9 records imports correctly except that the quotes are still around the
