execute an sqlquery and output as csv (handy for generating quikcndirty sql reports e.g.)

sql2csv

[[ ${#3} == 0 ]] && echo "Usage: [PASSWORD=""] $0 <dbname> <username> <query>" && exit 11

db="$1"
user="$2"
query="$3"

# execute query, quote quotes, and delimit with ","
mysql -u"$user" -p"$PASSWORD" "$db" -B -e "set names 'utf8'; $query" | \
  sed -e 's/"/\\"/g' |
  sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' | sed ':a;N;s/\r//g;s/\\n//g'