Ä¿µÄ:Ïë°ÑÎı¾ÖÐÊý×Öɸѡ³öÀ´,Öظ´Êý×ÖÖ»³öÏÖÒ»´Î. sh-2.05# cat log 1 1 2 3 3 4 4 5 6 6 [quote]sh-2.05# uniq -d log 1 3 4 6 [/quote] Ö»³öÏÖδÖظ´µÄÊý×Ö [quote]sh-2.05# uniq -u log 2 5 [code][/code][/quote][quote] ÏÖÔÚÎÒÖ»ÓаÑÁ½´Î½á¹ûµ¼ÈëÎı¾ÖÐ,ÓÃsortÅÅÐòºóµÃµ½½á¹û.ºÜÂé·³.ÎÒÏëµÃµ½logÎı¾ÖÐÍêÕûÊý×Ö,¶øÇÒ²»Öظ´,ÇëÎÊÔõôʵÏÖ. 1 2 3 4 5 6 [/quote]
by bobkey - Shell - 2005-05-01 12:16:06 ÔĶÁ£¨1278£© »Ø¸´£¨4£©
¼ÙÈçÓиöÎļþ£¬ÓÐ2ÁУ¬ÓÃtab»ò¿Õ¸ñ·Ö¿ª ÒªÌáÈ¡µÚ2ÁÐÖв»Öظ´µÄÐÐ ÀýÈçÓиöÎļþ file.txt 1 ÍõÈý 2 ÕÅÎå 3 ÍõÈý 4 ÀîÁù ÌáÈ¡½á¹ûÓ¦¸ÃΪ ÍõÈý ÕÅÎå ÀîÁù ÓÃshellʵÏÖ
#cat distinct.sh #!/bin/sh touch distinct.new awk '{if(NR == 1) print $0}' $1>./distinct.new count_line=`more $1|wc -l` init_var=2 while [ $count_line -ge $init_var ] do var=`awk '{if(NR == '"$init_var"' ) print $1}' $1` grep $var distinct.new if [ $? -eq 1 ] then awk '{if(NR == '"$init_var"' ) print $0}' $1 >>./distinct.new fi init_var=`expr $init_var + 1` done
ÏÖÔÚÏëʵÏÖÊäÈëÒ»¶¨µÄÌõ¼þ£¬ÏÔʾ³öÌõ¼þϵÄÏà¹ØÐÅÏ¢£¬ÆäÖв¿·ÖÐÅÏ¢ÊÇ¿ÉÐ޸ĵģ¬Óв¿·ÖÊDz»¿É¸ÄµÄ¡£ ÔÚÏÔʾÎļþÖÐÈçºÎÈçºÎÉèÖÃÕâÑùÒ»¸öÖ»ÓÃÓÚÏÔʾµÄ×ֶΣ¿ ÓÃdspdtrÂ𣿺óÃæ¸úÁ˼¸¸ö²ÎÊý£¬µ«ºÃÏñ²»Êǵġ£ »¹ÊÇÈ¥³ÌÐòÖнøÐж¨ÒåÈ¡Öµ£¿ÈçºÎ×öÄØ£¿
ÓÐA\BÁ½¸ö±í,ͬʱº¬ÓÐ"±àºÅ"×Ö¶Î,µ«ÊÇA±íÀïµÄ±àºÅ±ÈB±íÀïµÄ±àºÅÉÙ,ÏÖÔÚÏë°ÑA±íÀï±ÈB±íÀïÉٵıàºÅ¼Ç¼Ìí¼Óµ½B±í,²¢ÇÒ²»ÒªÖظ´µÄ¼Ç¼. insert ignore into A(±àºÅ) select ±àºÅ from B; Ϊʲô²»Äܳɹ¦ÄØ? [ ±¾Ìû×îºóÓÉ pkvs ÓÚ 2007-6-26 21:21 ±à¼ ]
ÎÒÏë´ÓÒ»ÅúÊý¾ÝÖÐÈ¡³öһЩ¼Ç¼£¬µ«ÕâЩ¼Ç¼ÖÐÓеÄidÓÐÖظ´µÄ£¬ÓеÄûÓУ¬ÎÒÏë±£ÁôûÓÐÖظ´µÄ¼Ç¼£¬µ«Öظ´µÄ¼Ç¼ÖÐÖ»±£ÁôÒ»Ìõ£¬ÇëÎʸÃÈçºÎʵÏÖ£¿