mysql --user=wibble --password wobble -B -e "select * from vehicle_categories;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > vehicle_categories.csv
Friday, September 19, 2014
Convert raw (batch) mysql command-line output to CSV
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment