Load csv file to mysql in dos

load data local infile 'file.csv' into table tablename fields terminated by ',' enclosed by '"' lines terminated by 'n' (field1,field2)