mysql load data infile default file location
snippet in sql

mysql load data infile csv

user9912

LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(col1, col2, col3, col4, col5...);

mysql load data infile default file location

user5624

C:\Program Files\MariaDB 5.5\data\yourDB