Import From CSV

load data local infile 'c:/csv.csv' into table db.csv
fields terminated by ','
optionally enclosed by '"'
lines terminated by '\r\n'
(field1, field2, field3)

Leave a Reply