Экспорт таблицы MySQL в .csv файл

Дата публикации: 23 11 2012 Автор: PazitiFF
SELECT id,name,qty FROM table_name INTO OUTFILE '/tmp/filename.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'


Спасибо, помогло

Add new comment

Plain text

  • No HTML tags allowed.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <apache>, <bash>, <css>, <drupal6>, <html5>, <javascript>, <mysql>, <php>.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.