Export Mysql result as CSV

9 years ago

Don't ask me how the sed magic works, but it does. Taken from here.

Running this: mysql -u<USER> -p<PASSWORD> <DATABASE> -B -e "select * from videos_video;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' will produce something like this: "id","title","url" "1","video 1","http://youtube(...)" "2","video 2","http://youtube(...)" "3","video 3","http://youtube(...)" Just pipe it to a .csv file and you're done :)