elsenorjose
Technical User
I'm loading a text file into a MySQL database using the following (specifics obfuscated out of confidentiality purposes)
The odd thing is that somehow during the load, everything is shifting one column to the right so that I end up with the data from field 2 in the text file in col3, field 4 in col5, etc. Very odd. Any thoughts?
MySQL 5.0.27 on Windows XP Pro SP2
Thank you!
Code:
LOAD DATA INFILE 'file.txt'
INTO TABLE test_temp
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
IGNORE 5 LINES
(col3, col5, col8, col10);The odd thing is that somehow during the load, everything is shifting one column to the right so that I end up with the data from field 2 in the text file in col3, field 4 in col5, etc. Very odd. Any thoughts?
MySQL 5.0.27 on Windows XP Pro SP2
Thank you!