OS
2015.07.27 23:44
csv를 MySQL로 삽입
조회 수 63861 추천 수 0 댓글 0
// 필드가 같을 때
LOAD DATA LOCAL INFILE "filePath"
INTO TABLE dbName.tableName FIELDS TERMINATED BY ",";
// 필드가 다를 때
LOAD DATA LOCAL INFILE './csv.csv'
INTO TABLE Stephanie.stock_data
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(itemcode, wdate, open, high, low, close);