I want to export my MYSQL Table data in to csv format with | or ~ delimited

Question

DB column data is multiline data , now i need to get result in single line

DB : Mysql Table name :: master_countries

so i want output in a single line comma delimited:

SELECT REPLACE(country, '\n' ,',')  FROM master_countries

Do you have linux or windows new lines? This thread might be useful, stackoverflow.com/questions/13273343/…. (I also would advise against this DB structure for this reason) — user3783243
– user3783243, Commented Aug 31, 2020 at 12:50

Arun surendharan · Accepted Answer · 2020-08-31 13:07:21Z

1

SELECT id,GROUP_CONCAT(country) FROM master_countries GROUP BY id;

answered Aug 31, 2020 at 13:07

Arun surendharan

611 silver badge6 bronze badges

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

1 Comment

country has multiple values in it, OP is trying to split on new lines.

mshahien · Accepted Answer · 2020-08-31 14:39:33Z

0

Try this :

SELECT REPLACE(country, '\r\n' ,',')  FROM master_countries

or

SELECT REPLACE(country, '\n\r' ,',')  FROM master_countries

answered Aug 31, 2020 at 12:51

mshahien

611 gold badge2 silver badges9 bronze badges

in phpmyadmin choose export then csv then choose Columns separated with:|

The provide code doesn't change the DB data. It selects and alters on the fly.

ok , then whats the issue ? is it not working ? SELECT REPLACE(country, '\n' ,',') if not try to put also SELECT REPLACE(country, '\n\r' ,',')

I don't know, it is not my question. Just pointing out an issue with the answer.