用SELECT和LOAD倒入数据

最新推荐文章于 2026-03-20 01:31:23 发布

原创最新推荐文章于 2026-03-20 01:31:23 发布 · 1.3k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#table #url #web

收录于

mysql 专栏收录该内容

2 篇文章

订阅专栏

博客内容主要涉及数据库操作，包含将 houseData 表中符合条件的数据导出到文件，以及将文件中的数据导入到 loupan_map 表，还进行了分组统计查询，体现了数据库数据的导出、导入及统计功能。

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