题解 | #netstat练习4-输出和3306端口#

#! /bin/bash
es=`cat nowcoder.txt | grep "3306" | grep "ESTABLISHED" | awk '{c++}END{printf("ESTABLISHED %s",c)}'`

cat nowcoder.txt | grep "3306" | awk '{print $5}' | awk -F ":" '{print $1}' | sort | uniq -c | awk  '{a+=$1;b++}END{printf("TOTAL_IP %s\nTOTAL_LINK %s\n",b,a)}' | 
sed "1a $es"