From: Edward <edward@roojs.com>
Date: Fri, 27 Jun 2014 05:11:36 +0000 (+0800)
Subject: mysql/core_cities_merge.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=3d845940c74c9f3a81f918961495c12c68f93f53

mysql/core_cities_merge.sql
---

diff --git a/mysql/core_cities_merge.sql b/mysql/core_cities_merge.sql
index 7ab5c572..dfa89ec7 100644
--- a/mysql/core_cities_merge.sql
+++ b/mysql/core_cities_merge.sql
@@ -482,8 +482,6 @@ CREATE FUNCTION core_city_blocks_mapping()  RETURNS INT DETERMINISTIC
         
         SELECT COUNT(DISTINCT(geoname_id)) INTO v_total FROM city_blocks WHERE geoname_id != 0  AND network_start_ip REGEXP '::ffff:[0-9]+.[0-9]+.[0-9]+.[0-9]+$';
 
-        SELECT v_total INTO outfile '/tmp/total.txt';
-
         SET v_count = 0;
 
         OPEN csr;
@@ -492,8 +490,6 @@ CREATE FUNCTION core_city_blocks_mapping()  RETURNS INT DETERMINISTIC
             
             SET v_count = v_count + 1;
             
-            SELECT v_count INTO outfile '/tmp/log.txt';
-
             SET v_country_id = 0;
             SET v_divison_id = 0;
             SET v_city_id = 0;