#!/bin/bash
TABFILE="tabfile.txt"
FILENAME="$1"#读入的文件名字,第一个参数
num=0;
#cat $FILENAME | iconv -f GBK -t UTF-8 | while read LINE
#do
#((num=$num+1))
#echo "line $num $LINE"
#echo $LINE
#awk -F '[\t]' '{printf $1 "\t" $2 "\t" $3 "\t" $4 "\t" $5 "\t" $6 "\t\n" }' $FILENAME | iconv -f GBK -t UTF-8 #
#awk -F '[\t]' '{printf "INSERT INTO t_info VALUES (" "\"" $1 "\", " "\"" $2 "\", " "\"" $3 "\", " "\"" $4 "\", " "\"" $5 "\", " "\"" $6 "\", " "NOW(), NOW() " ") FROM t_info WHERE NOT EXISTS (SELECT * FROM t_info WHERE Fcddf=\"" $1 "\");\n"}' $FILENAME | iconv -f GBK -t UTF-8
#awk -F '[\t]' '{printf "INSERT INTO t_info VALUES (" "\"" $1 "\", " "\"" $2 "\", " "\"" $3 "\", " "\"" $4 "\", " "\"" $5 "\", " "\"" $6 "\", " "NOW(), NOW() );\n"}' $FILENAME | iconv -f GBK -t UTF-8
#awk -F '[\t]' '{printf "INSERT INTO t_info(Fcddf, Fregion , Fmodel, Fnetwork , Fmem , Fcolor , Fcreate_time, Fupdate_time) select \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\", NOW(), NOW() from t_number_info WHERE NOT EXISTS (SELECT Fcddf FROM t_number_info WHERE Fcddf=\""$1"\");\n"}' $FILENAME | iconv -f GBK -t UTF-8
#done
#str="INSERT INTO t_number_info(Fcddf, Fregion , Fmodel, Fnetwork , Fmem , Fcolor , Fcreate_time, Fupdate_time) values"
#value=`awk -F '[\t]' '{printf "( \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\",NOW(), NOW() ),"}' $FILENAME | iconv -f GBK -t UTF-8`
#echo $str $value
b=0#判断是不是第一个数据
awk -F '[\t]' '{if($1 in a){ } else {a[$1];print $0 }}' $FILENAME | iconv -f GBK -t UTF-8 > "tabfile.txt"# iconv -f GBK -t UTF-8 的作用是中文乱码
str="INSERT ignore INTO t_number_info(Fcddf, Fregion , Fmodel, Fnetwork , Fmem , Fcolor , Fcreate_time, Fupdate_time) values"
value=`awk -F '[\t]' '{if(b>0){ printf ",( \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\",NOW(), NOW() )"}else{b+=1; printf "( \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\",NOW(), NOW() )"}}' $TABFILE`
echo $str $value ";"
TABFILE="tabfile.txt"
FILENAME="$1"#读入的文件名字,第一个参数
num=0;
#cat $FILENAME | iconv -f GBK -t UTF-8 | while read LINE
#do
#((num=$num+1))
#echo "line $num $LINE"
#echo $LINE
#awk -F '[\t]' '{printf $1 "\t" $2 "\t" $3 "\t" $4 "\t" $5 "\t" $6 "\t\n" }' $FILENAME | iconv -f GBK -t UTF-8 #
#awk -F '[\t]' '{printf "INSERT INTO t_info VALUES (" "\"" $1 "\", " "\"" $2 "\", " "\"" $3 "\", " "\"" $4 "\", " "\"" $5 "\", " "\"" $6 "\", " "NOW(), NOW() " ") FROM t_info WHERE NOT EXISTS (SELECT * FROM t_info WHERE Fcddf=\"" $1 "\");\n"}' $FILENAME | iconv -f GBK -t UTF-8
#awk -F '[\t]' '{printf "INSERT INTO t_info VALUES (" "\"" $1 "\", " "\"" $2 "\", " "\"" $3 "\", " "\"" $4 "\", " "\"" $5 "\", " "\"" $6 "\", " "NOW(), NOW() );\n"}' $FILENAME | iconv -f GBK -t UTF-8
#awk -F '[\t]' '{printf "INSERT INTO t_info(Fcddf, Fregion , Fmodel, Fnetwork , Fmem , Fcolor , Fcreate_time, Fupdate_time) select \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\", NOW(), NOW() from t_number_info WHERE NOT EXISTS (SELECT Fcddf FROM t_number_info WHERE Fcddf=\""$1"\");\n"}' $FILENAME | iconv -f GBK -t UTF-8
#done
#str="INSERT INTO t_number_info(Fcddf, Fregion , Fmodel, Fnetwork , Fmem , Fcolor , Fcreate_time, Fupdate_time) values"
#value=`awk -F '[\t]' '{printf "( \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\",NOW(), NOW() ),"}' $FILENAME | iconv -f GBK -t UTF-8`
#echo $str $value
b=0#判断是不是第一个数据
awk -F '[\t]' '{if($1 in a){ } else {a[$1];print $0 }}' $FILENAME | iconv -f GBK -t UTF-8 > "tabfile.txt"# iconv -f GBK -t UTF-8 的作用是中文乱码
str="INSERT ignore INTO t_number_info(Fcddf, Fregion , Fmodel, Fnetwork , Fmem , Fcolor , Fcreate_time, Fupdate_time) values"
value=`awk -F '[\t]' '{if(b>0){ printf ",( \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\",NOW(), NOW() )"}else{b+=1; printf "( \""$1"\", \""$2"\", \""$3"\", \""$4"\", \""$5"\", \""$6"\",NOW(), NOW() )"}}' $TABFILE`
echo $str $value ";"