Reticularium

NETWORKS PLACE

en|ru

Pretty easy:

mysql -u<username> -p<password> <dbname> -B -e "select * from <tablename>" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > <filename.csv>

Published by: Igor for section(s): ERR, Linux, ServersTo Contents
Created/updated at: 02.02.10/25.01.11
Tags: mysql