How to export a query to csv format ?

Here is the simple sample

mysql -uusername -ppassword databasename -B -e “select * from mytable” | sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;s/\n//g’ > filename.csv