资源描述：
《中国省市区三级数据库表-mysql》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、CREATETABLEhat_area(idint(11)NOTNULLauto_increment,areaIDvarchar(50)defaultNULL,areavarchar(60)defaultNULL,fathervarchar(6)defaultNULL,primarykey(id))ENGINE=MyISAMAUTO_INCREMENT=3145DEFAULTCHARSET=utf8;INSERTINTOhat_areaVALUES(1,'110101','东城区','110100');INSERTINTOhat_areaVALUES(2,'110102','西城区'
2、,'110100');INSERTINTOhat_areaVALUES(3,'110103','崇文区','110100');INSERTINTOhat_areaVALUES(4,'110104','宣武区','110100');INSERTINTOhat_areaVALUES(5,'110105','朝阳区','110100');INSERTINTOhat_areaVALUES(6,'110106','丰台区','110100');INSERTINTOhat_areaVALUES(7,'110107','石景山区','110100');INSERTINTOhat_areaVALUE
3、S(8,'110108','海淀区','110100');INSERTINTOhat_areaVALUES(9,'110109','门头沟区','110100');INSERTINTOhat_areaVALUES(10,'110111','房山区','110100');INSERTINTOhat_areaVALUES(11,'110112','通州区','110100');INSERTINTOhat_areaVALUES(12,'110113','顺义区','110100');INSERTINTOhat_areaVALUES(13,'110114','昌平区','110100');I
4、NSERTINTOhat_areaVALUES(14,'110115','大兴区','110100');INSERTINTOhat_areaVALUES(15,'110116','怀柔区','110100');INSERTINTOhat_areaVALUES(16,'110117','平谷区','110100');INSERTINTOhat_areaVALUES(17,'110228','密云县','110200');INSERTINTOhat_areaVALUES(18,'110229','延庆县','110200');INSERTINTOhat_areaVALUES(19,'12
5、0101','和平区','120100');INSERTINTOhat_areaVALUES(20,'120102','河东区','120100');INSERTINTOhat_areaVALUES(21,'120103','河西区','120100');INSERTINTOhat_areaVALUES(22,'120104','南开区','120100');INSERTINTOhat_areaVALUES(23,'120105','河北区','120100');INSERTINTOhat_areaVALUES(24,'120106','红桥区','120100');INSERTIN
6、TOhat_areaVALUES(25,'120107','塘沽区','120100');INSERTINTOhat_areaVALUES(26,'120108','汉沽区','120100');INSERTINTOhat_areaVALUES(27,'120109','大港区','120100');INSERTINTOhat_areaVALUES(28,'120110','东丽区','120100');INSERTINTOhat_areaVALUES(29,'120111','西青区','120100');INSERTINTOhat_areaVALUES(30,'120112','
7、津南区','120100');INSERTINTOhat_areaVALUES(31,'120113','北辰区','120100');INSERTINTOhat_areaVALUES(32,'120114','武清区','120100');INSERTINTOhat_areaVALUES(33,'120115','宝坻区','120100');INSERTINTOhat_areaVALUES(34,'120221','宁河县','120200');INS
