shell-mysql(综合)

tab转空格

sed 's/\t/ /g' add_price >addPrice

cat add_price|tr  "\t" " " >addPrice

查询占用某个端口的进程

netstat -p |grep "20881"

tcp        0      0 l-s.f.dev.cn6:20881   l-s.f.dev.cn6.q:44699 ESTABLISHED 7987/java    

启动linux机器上的 http 服务

 python -m SimpleHTTPServer 9393

其他机器下载：

 http://10.86.141.38:9393/autochk.exe

mysql $db -uuser_name -ppassword -123.168.24.000 -P3306 --default-character-set=utf8 -e"select * from permissions"

#!/bin/sh

uname='***'
pword='***'
vdb='***'
dbhost='127.0.0.1'
dbport=3306

echo $1
sql=$1
domain=''
mysql $vdb -u$uname -p$pword -h$dbhost  -sN -e"select host,port,clientId,databaseName from client_shard">cc.data

function p
{
        while read line
        do
                echo $domain","$line
        done<$1
}

while read line
do
  host=$(echo $line|cut -f1 -d' ')
  client=$(echo $line|cut -f3 -d' ')
  db=$(echo $line|cut -f4 -d' ')
  domain=$client
  mysql $db -u$uname -p$pword -h$host -P3306 --default-character-set=utf8 -e"$sql">.tmp
  p .tmp
done<cs.data