cat test1.txt | awk '{print "select videoid from video where infohash=""'\''"$1"'\'';"}' > movieid.txt
mysql -h192.168.1.15 -uroot --column-names=false < movieid.txt > movie.txt
cat movie.txt | sort -n | uniq | wc -l
cat test1.txt | awk '{print "select videoid from video where infohash=""'\''"$1"'\'';"}' > movieid.txt
mysql -h192.168.1.15 -uroot --column-names=false < movieid.txt > movie.txt
cat movie.txt | sort -n | uniq | wc -l