13 September 2012

Imprt CSV into MYSQL


LOAD DATA  LOCAL INFILE 'D:\\srikanth\\CustomerConnections2.csv' INTO TABLE tables_portal COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

No comments: