I'm using 3.23.49 on Windoze 98. I'm trying to execute this:
mysqlc> load data local infile "c:/temp/e-headhunters.txt"
-> into table headhunters
-> lines terminated by '\r\n'
-> (email);
Table headhunters contains several fields, including
'email varchar(40)'.
The input file is text, with lines terminated by x'0d0a', confirmed
with a hex editor. It contains simple strings:
ilsglobe.com
baxley.com
ComputerJobs.com
coloradojobs.com
dice.com
MySQL inputs one record into the table, consisting of the
first two lines above, concatenated with a newline, into
the email field. I.e., the sole resulting record consists of one
string, "ilsglobe.com<nl>baxley.com" in the email field. (It's
possible that the embedded newline is <cr><nl>.) There are
(untrappable) warnings issued for the rest.
I've tried every combination of LINES TERMINATED BY, FIELDS TERMINATED
BY, and FIELDS ENCLOSED BY that I can think of, and nothing works.
I'm new at this so I'm probably doing something wrong.
Any help, please.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
