LOAD DATA INFILE help

["Tyler Longren" <tyler@xxxxxxxxxxxxxxx>]

Hello,

I've been struggling with this all night.  Can someone give me a push?  I
have a csv file named Sheet1.txt, here's an example of its contents:
"P1002565",
"P1002566",
"P1002638",

I want to put the contents of Sheet1.txt in a table named 'passcodes'.  The
passcodes table has 2 fields: 'id' and 'passcode'.  I run this:
LOAD DATA INFILE 'Sheet1.txt' INTO TABLE passcodes FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n';

Nothing gets inserted into the 'passcode' field, but ID's are generated for
every item in Sheet1.txt.

Can anyone give me some help?

Thanks,
Tyler Longren


---------------------------------------------------------------------
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 <mysql-thread92814@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php