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