公司技术积累

mysql -ufortuna -pfortuna_db_connections -h10.20.35.185 fortuna_fish -e "select user_id, device_token from fish_user where language='zh_TW' and level>15 and udpate_time>='2013-10-01 00:00:00' and udpate_time<'2013-12-11 00:00:00'">tw.txt

cat cn.txt | sort -u -k 2 >> 1.txt
cat 1.txt | cut -f 1 > 2.txt
split -l 10000 2.txt cn_
find . -type f | xargs -i mv {} {}.txt

-type 指定文件类型 f为普通文件
-name 为按文件查找