Export JSON data from MySQL table to CSV

Question

I used the following command to export some fields of MySQL table including a JSON field(attributes) into CSV file:

SELECT name, attributes, product_url FROM products INTO OUTFILE '/var/lib/mysql-files/toys.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

But, I get each key-value pair of attributes(JSON field) in separate columns.

How to get all those key-values(attributes column of MySQL table) in a single column of CSV file?

Vipool · Accepted Answer · 2019-08-31 11:39:29Z

1

I found a solution that was enough to get my job done. I exported those fields into TSV instead of CSV using following slightly modified command:

SELECT name, attributes, product_url FROM products INTO OUTFILE '/var/lib/mysql-files/toys.tsv' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

Still, if anyone has an exact solution to the problem, that would be greatly appreciated.

answered Aug 31, 2019 at 11:39

Vipool

1081 silver badge12 bronze badges

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

Collectives™ on Stack Overflow

Export JSON data from MySQL table to CSV

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related