Import CSV file into MYSQL

LOAD DATA INFILE 'myfile' INTO TABLE table FIELDS TERMINATED BY ',';