Hello everyone, I posted this message to the mysql mailing list and didn't get a response. I know a lot of people here are good with SQL. So, here's my e-mail:
Hello, I've been struggling with this all night. Can someone give me a push in the right direction? 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? Sorry for the sort of off-topic question! Thanks, Tyler Longren -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
