MYSQL: import csv data into table

import-csv-data-into-table.sql

# Create table with same csv headers.
CREATE TABLE table_name ( id mediumint(9) NOT NULL, {..}, PRIMARY KEY (id) );

# Load csv into table.
LOAD DATA INFILE '{abspath}/my-data.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;