Write CSV from MySQL?

Question

I'm trying to export a table in MySQL as a CSV, but I'm having trouble. I've tried two approaches, neither of which have worked.

First:

SELECT * 
INTO OUTFILE '/path/to/filename.csv' 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
ESCAPED BY '\\' 
LINES TERMINATED BY '\n' 
FROM table;

Second:

mysqldump -u [username] -p -t -T/path/to/directory [database] [table] --fields-enclosed-by=\" --fields-terminated-by=,

What is wrong with the first one?

Devart
– Devart

2012-08-27 07:17:23 +00:00
Commented Aug 27, 2012 at 7:17 — Devart
– Devart, Commented Aug 27, 2012 at 7:17

John Woo · Accepted Answer · 2012-08-27 05:49:39Z

1

try this example,

SELECT order_id,product_name,qty FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

SOURCE

answered Aug 27, 2012 at 5:49

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

milind_db · Accepted Answer · 2012-08-27 06:33:20Z

0

SELECT order_id,product_name,qty FROM orders INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'

is correct if it is not worked then try to avoid path of the file....just give file name and after execution look resulted file in '/var/lib/mysql/dbname'.

answered Aug 27, 2012 at 6:33

milind_db

1,2945 gold badges34 silver badges57 bronze badges

Collectives™ on Stack Overflow

Write CSV from MySQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related