I am going to experiment with the input file function of Mysql tomorrow
I have spent an hour editing a 650 line excel file and saved it as tab
Then in word I converted the tabs to "," .
In some fields I have commas inside the quotes and I assume that this
will not mess things up?
Some fields are empty so I include them with ,"",
I don't have the \n ,which I will use to terminate the lines, in quotes
- is that correct?
Here is a sample :
Address,"City",NC,Zipcode,Phone,"",Teacher, NC 28098\n
Address,City,NC,Zipcode,"Phone",",Senior Military Assistant, US
Here is how I plan to insert this data - please let me know if this is
Load Data Infile "data.txt" into table TableName
TERMINATED by ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Thanks in advance,
Appalachian State University
Boone, NC 28607