【MySQL】CSVファイルをインポートするコマンド - Qiita# TERMINATED BY 区切り文字 # ENCLOSED BY 囲み文字 LOAD DATA LOCAL INFILE '/tmp/import.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' # データを入れるカラムを指定 LOAD DATA LOCAL INFILE '/tmp/import.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' (column1, column2) Register as a new user and use Qiita more conveniently You get articles that match your needsYou can efficiently rea
