#!/bin/bash
echo -n "mysql host: "
read ip
echo -n "mysql port: "
read port
echo -n "mysql user: "
read usr
echo -n "mysql password: "
read pswd
echo -n "mysql database: "
read base
echo -n "sql: "
read sql
name=`date +%s`
`mysql -h$ip -P$port -u$usr -p$pswd -D$base -e "$sql" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > $name.csv`
`zip $name.zip $name.csv`
`rm -rf $name.csv`