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’;
Tag: Load Data from CSV
Permanent link to this article: https://blog.openshell.in/2010/12/importing-data-from-csv-file/