how to export a table in .csv file

$ mysql -u[username] -p[password] [nome_database] -B -e “select * from \`[nome_tabella]\`;” | sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;s/\n//g’ > /var/www/html/cicciofile.csv

View this command to comment, vote or add to favourites
View all commands by 0disse0

by David Winterbottom (codeinthehole.com)

Tags: bash cmd Commands shell scripts