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)
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' #(上周六)