shell脚本生成统计信息

MYSQL_BIN="/usr/local/mysql/bin/mysql"

$MYSQL_BIN -u root -pming -e "select prod_id,prod_num from shop.order_detail " -N | sort -r |awk "
  BEGIN{
         old="";count=0
  }
   {
           if(old!=$1 && old!=""){
              print old"    "count;
              old=$1;
              count=1;
           }
           else{
                old=$1;
                count=$2;  
           }
   }
   END{ print old"    "count; }
"| sort -nr -k 2