test.log

1;0;112;1;223;3;335

　　

 

#!/bin/shecho $#if [[ $# > 0 ]];then        green_day=$1else        green_day=`date +%Y%m%d`fi 阿萨德echo $green_daylog_day=`date +%Y-%m-%d -d "1 day ago $green_day"`echo $log_daymonth=`date +%Y-%m -d "$log_day"`day=`date +%d -d "$log_day"`echo "greenday:$green_day logday:$log_day"LOG_DIR=/root/to/path/$month/$dayecho $LOG_DIRsed -e 's/;[^01]/9/g' -e 's/5/8/g' test.logawk -F';' 'BEGIN{OFS="\t"}{if(($1 == 1 && $2 == 0) || $1 == 2){print '$green_day',FILENAME,$1,$2,$3}}' test.log

awk

cat test.log |awk  -F';' 'BEGIN{OFS="\t"} $1=='1' {a1++;a2++} {print a1,a2,$1,$2,$3} END{print a1}'

　　

a1/a2初始值为0,

 MySQL

mysql -h127.0.0.1 -uuser -ppwd -D database -e "show tables;delete from table_name where date='$green_day';LOAD DATA LOCAL INFILE 'xx.log' INTO TABLE table_name(field1,field2);"