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
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