[DB] MySQL CSV import

• local-infile 권한으로 접속해야 한다

mysql --local-infile=1 -h db.com -u me -p

LOAD DATA LOCAL INFILE 'Desktop/file.csv'
INTO TABLE MY_DB.MY_TABLE
CHARACTER SET utf8mb4
FIELDS
  TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"'
  ESCAPED BY ''
LINES
  TERMINATED BY '\r\n'
IGNORE 1 LINES
(@c1,@c2)
SET id=@c2,name=@c1
;