2009-08-06から1日間の記事一覧
LOAD DATA LOCAL INFILE '/home/hoge/hoge.csv' INTO TABLE `hoge` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; TERMINATED BY 'カラムの区切り' ENCLOSED BY '' フィールド値の両端に現れた場合、その文字は取り…
LOAD DATA LOCAL INFILE '/home/hoge/hoge.csv' INTO TABLE `hoge` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; TERMINATED BY 'カラムの区切り' ENCLOSED BY '' フィールド値の両端に現れた場合、その文字は取り…