load csv data file into database

load data local infile 'C:/contact_csv2.csv'

into table TestSchema.TestTable fields terminated by ',' enclosed by '"'

lines terminated by '\n'

Where TestSchema is database, TestTable is table name, use '\n' if .csv file generated by PC, use '\r' if .csv file generated by Mac