How ti import CSV file into MySQL table

LOAD DATA INFILE "file.csv"
INTO TABLE __source_data
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n';

OR

LOAD DATA INFILE "/home/mike/data.csv"
INTO TABLE my_TABLE
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;