• 22/04/18

• 22/05/11

• csv 파일 빠르게 import하기

LOAD DATA INFILE '/var/lib/mysql-files/product2.csv' 
INTO TABLE product 
CHARACTER SET euckr
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(naver_id,created_date,modified_date,name,buy_url,price,image_url,category1,category2,category3,keyword,brand,hit,wish,give,recommend);