brpaz
11/2/2014 - 10:38 AM

mysql export table into CSV file #mysql #csv

mysql export table into CSV file #mysql #csv

mysql -u USERNAME -p DATABASE -e "select * from TABLE;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g'