Экспорт csv в mysql таблицу

Опубликовано: 2015-04-29 10:36:33

LOAD DATA LOCAL INFILE '/tmp/file.csv'

INTO TABLE db_project.table_N

FIELDS TERMINATED BY ';'

ENCLOSED BY '"'

LINES TERMINATED BY '\n'

IGNORE 1 ROWS;