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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php