Easy way to import data from csv files in MySQL

We all know that these days we have all types of GUI tools that can help us import data into MySQL from various formats including csv format(comma separated values).  But in some cases we need to incorporate a data import via shell/sql scripts that are part of a home cooked ETL process(also this is done using less resources).  What is the basic syntax for use to do a data import from a csv file into a MySQL table.

LOAD DATA INFILE '/tmp/file.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY 'n'

GRANT FILE ON *.* TO 'user'@'host';

mysql LOAD DATA INFILE '/tmp/functions.csv'
 - INTO TABLE functions_innodb
 - FIELDS TERMINATED BY ','
 - ENCLOSED BY '"'
 - LINES TERMINATED BY 'n'
 - ;
Query OK, 17418 rows affected (0.37 sec)
Records: 17418 Deleted: 0 Skipped: 0 Warnings: 0