Import CSV File Into MySQL Table

LOAD DATA LOCAL INFILE  ‘./table_name.csv’

INTO TABLE table_name

FIELDS TERMINATED BY ‘,’

ENCLOSED BY ‘”‘

LINES TERMINATED BY ‘\n’

IGNORE 1 ROWS;