MySql command line csv [duplicate]

Question

Is there a way to use the following command to output in comma separated instead of tab separated.

echo "select col1, col2, col3 from newtable" | mysql --column-names > data.csv

It outputs the following.

col1    col2    col3   
1       Test    Test 1
2       Test    Test 2
3       Test    Test 3

how do I output a comma seperated file.

Hope this could be helpful: stackoverflow.com/questions/356578/… — Andrea Rastelli
– Andrea Rastelli, Commented Oct 25, 2017 at 16:47

Matthieu.V · Accepted Answer · 2017-10-25 16:51:00Z

3

Just use tr to replace tabulations by commas:

echo "select col1, col2, col3 from newtable" | mysql --column-names | tr "\t" ";" > data.csv

answered Oct 25, 2017 at 16:51

Matthieu.V

18310 bronze badges

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

1 Answer 1