mysql -u root -p’mysqlpasswordhere’ dbnamehere -B -e “select * from anytable;” | sed “s/’/\’/;s/\t/\”,\”/g;s/^/\”/;s/$/\”/;s/\n//g” > /var/lib/mysql-files/anyfilename.csv
mysql -u root -p’mysqlpasswordhere’ dbnamehere -B -e “select * from anytable;” | sed “s/’/\’/;s/\t/\”,\”/g;s/^/\”/;s/$/\”/;s/\n//g” > /var/lib/mysql-files/anyfilename.csv