LOAD DATA LOCAL INFILE '/tmp/hoge.csv' INTO TABLE hoge FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
テーブルは事前に用意しておく必要あり
LOAD DATA LOCAL INFILE '/tmp/hoge.csv' INTO TABLE hoge FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
テーブルは事前に用意しておく必要あり