mi tumblr
joaquin núñez
April 9, 2009
Command line: Export from MySQL to CSV

mysql -uexampleuser -pletmein exampledb -B -e "select * from \`person\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv

thx bawdo2001