用SELECT和LOAD倒入数据

 

select name,id,sale_phone,address,jiaotong,REPLACE(REPLACE(SUBSTRING(comment,1,500),'/r/n',''),'"',''),web_url,sold_ratio,kaipan_time,price_average,developer INTO OUTFILE '/home/david/house.txt' FIELDS TERMINATED BY ','  ENCLOSED BY '"' ESCAPED BY '' from houseData where is_loaded>0 AND status>0 AND districtId=11;

LOAD DATA INFILE '/home/david/map.txt' INTO TABLE loupan_map FIELDS TERMINATED BY ','  (map_id,loupan_id);
select count(*),district_name from houseData,district where houseData.districtId=district.did AND is_loaded>0 and status>0 group by districtId