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:
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:
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!
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]