常用shell乱弹

一、Mysql相关

1. 

1.sh
#!/bin/bash

LOG_FILE=local_ip.txt
mysql="mysql -h${HOST} -P{PORT} -u${USER} -p${PASSWD} --default-character-set=utf8 ${DB_NAME} -ABN -e"
$mysql " select * from ${TABLE_NA,E}" > select.log

注意： select前有空格。

2.sh

#!/bin/bash
delay=`date -d "1 day ago" "+%Y-%m-%d"`
if [ $# -eq 1 ]; then
delay=`date -d "$1 day ago" "+%Y-%m-%d"`
fi
echo "select guid,OtherReason from master_5002_user_feedback where date=\"${delay}\"" \
|mysql -h10.163.170.13 -P3306 -umaster -pmaster@253 stat -ABN >> uninstall.log.$delay
#|mysql -h10.163.170.13 -P3306 -umaster -pmaster@253 --default-character-set=utf8 stat -ABN >> uninstall.log.$delay
iconv -f gbk -t utf8 uninstall.log.$delay -o uninstall.log.${delay}.utf8
cat uninstall.log.${delay}.utf8 | grep -e "***" -e"***" > result.uninstall.log.$delay

3.sh

#!/bin/bash
mv uninstall.log.${delay}.utf8 back.uninstall.log.${delay}.utf8
delay=`date -d "1 day ago" "+%Y-%m-%d"`
if [ $# -eq 1 ]; then
delay=`date -d "$1 day ago" "+%Y-%m-%d"`
fi
echo "select guid,OtherReason from master_5002_user_feedback where date=\"${delay}\"" \
|mysql -h10.163.170.13 -P3306 -umaster -pmaster@253 stat -ABN >> uninstall.log.$delay
cat uninstall.log.${delay} | while read line ; do echo $line | iconv -f gbk -t utf8 >> uninstall.log.${delay}.utf8; done
cat uninstall.log.${delay}.utf8 | grep -e "杀毒" -e "木马" -e "误报" -e "误删" > result.uninstall.log.$delay