Importing data from CSV File

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';