请找管理员授权。/funnyscript/edit_node_item.php
source /root/happyli/shell/lib/library.sh mypath2="/data/chengde/cznl_map_data2" ##funny_sql 统计 echo " 统计分数 " $funny_sql \ $mypath2/test_0.txt.out.txt 250000 "select round(c20*100),0 from test" , \ $mypath2/test_0.txt.out.0.txt $funny_sql \ $mypath2/test_1.txt.out.txt 250000 "select round(c20*100),1 from test" , \ $mypath2/test_1.txt.out.1.txt echo " 合并文件 " cat $mypath2/test_0.txt.out.0.txt \ $mypath2/test_1.txt.out.1.txt>$mypath2/test_out.txt echo " 统计结果 " $funny_sql \ $mypath2/test_out.txt 250000 \ "select c1,sum(c2),count(1)-sum(c2) from test group by c1" , \ $mypath2/result.txt # =SUM(B$1:B67)/SUM(B:B) $funny_ks $mypath2/result.txt 0 1 2
ID=5136 step5 结果 0.41616;3.0643% 过滤148个
保存
source /root/happyli/shell/lib/library.sh mypath2="/data/chengde/cznl_map_data2" ##funny_sql 统计 echo " 统计分数 " $funny_sql \ $mypath2/test_0.txt.out.txt 250000 "select round(c20*100),0 from test" , \ $mypath2/test_0.txt.out.0.txt $funny_sql \ $mypath2/test_1.txt.out.txt 250000 "select round(c20*100),1 from test" , \ $mypath2/test_1.txt.out.1.txt echo " 合并文件 " cat $mypath2/test_0.txt.out.0.txt \ $mypath2/test_1.txt.out.1.txt>$mypath2/test_out.txt echo " 统计结果 " $funny_sql \ $mypath2/test_out.txt 250000 \ "select c1,sum(c2),count(1)-sum(c2) from test group by c1" , \ $mypath2/result.txt # =SUM(B$1:B67)/SUM(B:B) $funny_ks $mypath2/result.txt 0 1 2