Here is an example to importing data from csv file into MySQL table.
LOAD DATA INFILE “/home/mysql/data/file_name.csv” INTO TABLE table_name FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\\n’;
Dec 10
Importing data from CSV File
Permanent link to this article: https://blog.openshell.in/2010/12/importing-data-from-csv-file/