Import CSV Data File Into MySQL Table

LOAD DATA INFILE "D:/test.csv"
INTO TABLE desire_table_name
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r';