Select Name, ID, Sale_Phone, Address, Jiaotong, Replace (Replace (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 managementID = 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
