Load CSV back into mySQL

Submitted by:David Villa

Date added:19 May, 2012

Category:MySQL

Example code to load CSV back into mySQL

Tags: csv to mysql

Code Snippet:

    LOAD DATA local INFILE 'unique.csv' INTO TABLE tablename
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(col1, col2, col3)
 
 

Comments