Database/MySQL

[MySQL] csv 파일 import 하기

opid 2014. 7. 23. 16:52
LOAD DATA LOCAL INFILE 'D:/project/file.csv' 
INTO TABLE dbName.tableName
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
IGNORE 1 ROWS;

참조 Link