Export MySQL query as .csv file

echo "SELECT * FROM table; " | mysql -u root -p${MYSQLROOTPW} databasename | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > outfile.csv
This command converts a MySQL query directly into a .csv (Comma Seperated Value)-file.
Sample Output
no output

8
2009-02-16 18:55:18

What Others Think

Or you could use the "SELECT * INTO OUTFILE " syntax http://dev.mysql.com/doc/refman/5.1/en/select.html
mydarb · 697 weeks and 1 day ago
Even if it's just in your wildest dreams doula jacksonville fl
tillyracker · 53 weeks and 1 day ago
https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/   https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/ https://seofox.ir/gray-hat-seo/
seofox · 31 weeks and 4 days ago
adaksepehr · 24 weeks and 2 days ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: