- Save Excel worksheet as .csv file
- might need to change new line characters
- if saving on Mac - open in vi and run
%s/^M/\r/g
( ctrl+M )
- Use the following example to load in CSV file from mysql prompt -
load data infile '/tmp/tc_t.csv'
into table new_test_categories
fields terminated by ','