- 论坛徽章:
- 0
|
- #!/bin/sh
- yesterday=$(date -d"yesterday" +%Y-%m-%d)
- echo $yesterday
- basedir="/tmp/"
- filename=$basedir"dispacher.log."$yesterday
- if [ -e $filename ]; then
- echo "文件存在!"
- awk -v strdate=$(date -d"yesterday" +%Y%m%d) -F"|" 'BEGIN{OFS = ","}{a[$6]++;}{if(!c[$6,$4]++){b[$6]++}}END{for(i in a) {print "replace into f_stat_day set total_brower="a[i]",total_user="b[i]",crt_time=now(),stat_date="strdate",local_code="i";" }}' $filenam > mysql -uroot -p123456 test
- else
- echo "文件不存在!"
- fi
复制代码
不知道awk生成的sql如何导入到mysql中,请赐教! |
|