/ Published in: MySQL

Expand |
Embed | Plain Text
LOAD DATA local INFILE 'unique.csv' INTO TABLE tablename FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (col1, col2, col3)
Comments

You need to login to post a comment.
matula on 09/17/10
5 people have marked this snippet as a favorite
davidsi
dimispaceman
kubaitis
benastan
jeremydouglass
LOAD DATA local INFILE 'unique.csv' INTO TABLE tablename FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (col1, col2, col3)
You need to login to post a comment.
freakin dank bud