mysql/core_cities_merge.sql
authorEdward <edward@roojs.com>
Thu, 26 Jun 2014 10:25:34 +0000 (18:25 +0800)
committerEdward <edward@roojs.com>
Thu, 26 Jun 2014 10:25:34 +0000 (18:25 +0800)
mysql/core_cities_merge.sql

index fe392eb..e942102 100644 (file)
@@ -255,7 +255,7 @@ CREATE FUNCTION core_country_locations()  RETURNS INT DETERMINISTIC
         FROM 
             country_locations
         
-        SELECT COUNT(*) INTO v_total FROM country_locations;
+        SELECT COUNT(geoname_id) INTO v_total FROM country_locations;
 
         SET v_count = 0;