记录下sql

SELECT DISTINCT country FROM geoipcountrywhois where country NOT IN (SELECT cc FROM cc ORDER BY cc)

SELECT geoipcountrywhois.`start`,geoipcountrywhois.`end`,cc.ci FROM geoipcountrywhois JOIN cc WHERE geoipcountrywhois.country=cc.cc;

SELECT cc FROM cc where cc NOT IN (SELECT DISTINCT country FROM geoipcountrywhois)

UPDATE geoipcountrywhois AS ab1 INNER JOIN cc AS ab2 ON ab1.country=ab2.cc SET ab1.country = ab2.ci;

#上周生成特征数量
select * from bn_sig_info 
where status='active' 
	and create_time>'2011-09-17'  #（上上周六）
	and create_time<'2011-09-24'  #（上周六）

#上周国内特征数量
select count(*) from bn_sig_info NATURAL JOIN ip
where inet_aton(SUBSTRING_INDEX(SUBSTRING(sig_content,5), ':', 1)) >=start
    AND inet_aton(SUBSTRING_INDEX(SUBSTRING(sig_content,5), ':', 1)) <= end
    and ci=32    # 中国
    and status ='active'
    and create_time>'2011-09-17'  #（上上周六）
    and create_time<'2011-09-24'  #（上周六）