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;

Import CSV file into MYSQL

LOAD DATA INFILE 'myfile' INTO TABLE table FIELDS TERMINATED BY ',';

mysql to CSV file

SELECT * INTO OUTFILE 'result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM my_table;