Data operationsMySQL
LOAD DATA INFILE
Bulk import data from flat files.
Command
LOAD DATA LOCAL INFILE '.csv' INTO TABLE FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' IGNORE 1 LINES;
Example usage
Load CSV data efficiently while skipping header rows.
LOAD DATA LOCAL INFILE '<path>.csv' INTO TABLE <table> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' IGNORE 1 LINES;Related tags
Data operationsdatabasesqlinnodb