I have an excel spreadsheet that has all the data I need in my mysql database. One field, location, stores a varchar of a directory, such as "exdir\exsubdir\" I created a tab delimited file from the spreadsheet and LOAD DATA LOCAL INFILE the data into the mysql database. The first time through, it simply stripped the "\" from location. So, I read that I needed to escape the \ with another \ which makes sense. I did a find and replace on all \ in my spreadsheet in the location column. There were no \ in any other columns. When I redid the load data, the database only pulled up to the second row of data from the tab delimited file. All the rest of the rows are filled with null values. What gives?
