资源描述：
《中国省市区三级数据库表sql.》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、#MySQL-Front5.1(Build2.7)/*!40101SET@OLD_SQL_MODE=@@SQL_MODE*/;/*!40101SETSQL_MODE=''*/;/*!40111SET@OLD_SQL_NOTES=@@SQL_NOTES*/;/*!40103SETSQL_NOTES='ON'*/;#Host:localhostDatabase:iptohat_area#------------------------------------------------------#Serverversion5.0.26##Sourcefortableh
2、at_area#CREATETABLEhat_area(idint(11)NOTNULLauto_increment,areaIDvarchar(50)defaultNULL,areavarchar(60)defaultNULL,fathervarchar(6)defaultNULL,primarykey(id))ENGINE=MyISAMAUTO_INCREMENT=3145DEFAULTCHARSET=utf8;##Dumpingdatafortablehat_area#INSERTINTOhat_areaVALUES(1,'110101','东城区','1
3、10100');INSERTINTOhat_areaVALUES(2,'110102','西城区','110100');INSERTINTOhat_areaVALUES(3,'110103','崇文区','110100');INSERTINTOhat_areaVALUES(4,'110104','宣武区','110100');INSERTINTOhat_areaVALUES(5,'110105','朝阳区','110100');INSERTINTOhat_areaVALUES(6,'110106','丰台区','110100');INSERTINTOhat_ar
4、eaVALUES(7,'110107','石景山区','110100');INSERTINTOhat_areaVALUES(8,'110108','海淀区','110100');INSERTINTOhat_areaVALUES(9,'110109','门头沟区','110100');INSERTINTOhat_areaVALUES(10,'110111','房山区','110100');INSERTINTOhat_areaVALUES(11,'110112','通州区','110100');INSERTINTOhat_areaVALUES(12,'110113'
5、,'顺义区','110100');INSERTINTOhat_areaVALUES(13,'110114','昌平区','110100');INSERTINTOhat_areaVALUES(14,'110115','大兴区','110100');INSERTINTOhat_areaVALUES(15,'110116','怀柔区','110100');INSERTINTOhat_areaVALUES(16,'110117','平谷区','110100');INSERTINTOhat_areaVALUES(17,'110228','密云县','110200');IN
6、SERTINTOhat_areaVALUES(18,'110229','延庆县','110200');INSERTINTOhat_areaVALUES(19,'120101','和平区','120100');INSERTINTOhat_areaVALUES(20,'120102','河东区','120100');INSERTINTOhat_areaVALUES(21,'120103','河西区','120100');INSERTINTOhat_areaVALUES(22,'120104','南开区','120100');INSERTINTOhat_areaVAL
7、UES(23,'120105','河北区','120100');INSERTINTOhat_areaVALUES(24,'120106','红桥区','120100');INSERTINTOhat_areaVALUES(25,'120107','塘沽区','120100');INSERTINTOhat_areaVALUES(26,'120108','汉沽区','120100');INSERTINTOhat_areaVALUES(27,'120109','大港区','120100');INSERTINTOhat_areaVALUES(28,'120110','东丽
8、区','120100')
