Answers for "mysql import data from large csv file using load data infile"

MySQL import data from large CSV file

LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY 'rn' 
IGNORE 1 LINES;

Posted by: Guest on February-23-2021

Code answers related to "mysql import data from large csv file using load data infile"