quan中国省市区三级数据库表.sql
# MySQL-Front 5.1 (Build 2.7)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
# Host: localhost Database: iptohat_area
# ------------------------------------------------------
# Server version 5.0.26
#
# Source for table hat_area
#
CREATE TABLE hat_area (
id int(11) NOT NULL auto_increment,
areaID varchar(50) default NULL,
area varchar(60) default NULL,
father varchar(6) default NULL,
primary key(id)
) ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8;
#
# Dumping data for table hat_area
#
INSERT INTO hat_area VALUES (1,'110101','东城区','110100'); INSERT INTO hat_area VALUES (2,'110102','西城区','110100'); INSERT INTO hat_area VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_area VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_area VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_area VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_area VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_area VALUES (10,'110111','房山区','110100'); INSERT INTO hat_area VALUES (11,'110112','通州区','110100'); INSERT INTO hat_area VALUES (12,'110113','顺义区','110100'); INSERT INTO hat_area VALUES (13,'110114','昌平区','110100'); INSERT INTO hat_area VALUES (14,'110115','大兴区','110100'); INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100'); INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');
INSERT INTO hat_area VALUES (18,'110229','延庆县','110200'); INSERT INTO hat_area VALUES (19,'120101','和平区','120100'); INSERT INTO hat_area VALUES (20,'120102','河东区','120100'); INSERT INTO hat_area VALUES (21,'120103','河西区','120100'); INSERT INTO hat_area VALUES (22,'120104','南开区','120100'); INSERT INTO hat_area VALUES (23,'120105','河北区','120100'); INSERT INTO hat_area VALUES (24,'120106','红桥区','120100'); INSERT INTO hat_area VALUES (25,'120107','塘沽区','120100'); INSERT INTO hat_area VALUES (26,'120108','汉沽区','120100'); INSERT INTO hat_area VALUES (27,'120109','大港区','120100'); INSERT INTO hat_area VALUES (28,'120110','东丽区','120100'); INSERT INTO hat_area VALUES (29,'120111','西青区','120100'); INSERT INTO hat_area VALUES (30,'120112','津南区','120100'); INSERT INTO hat_area VALUES (31,'120113','北辰区','120100'); INSERT INTO hat_area VALUES (32,'120114','武清区','120100'); INSERT INTO hat_area VALUES (33,'120115','宝坻区','120100'); INSERT INTO hat_area VALUES (34,'120221','宁河县','120200'); INSERT INTO hat_area VALUES (35,'120223','静海县','120200'); INSERT INTO hat_area VALUES (36,'120225','蓟县','120200'); INSERT INTO hat_area VALUES (37,'130101','市辖区','130100'); INSERT INTO hat_area VALUES (38,'130102','长安区','130100'); INSERT INTO hat_area VALUES (39,'130103','桥东区','130100'); INSERT INTO hat_area VALUES (40,'130104','桥西区','130100'); INSERT INTO hat_area VALUES (41,'130105','新华区','130100'); INSERT INTO hat_area VALUES (42,'130107','井陉矿区','130100'); INSERT INTO hat_area VALUES (43,'130108','裕华区','130100'); INSERT INTO hat_area VALUES (44,'130121','井陉县','130100'); INSERT INTO hat_area VALUES (45,'130123','正定县','130100'); INSERT INTO hat_area VALUES (46,'130124','栾城县','130100'); INSERT INTO hat_area VALUES (47,'130125','行唐县','130100'); INSERT INTO hat_area VALUES (48,'130126','灵寿县','130100'); INSERT INTO hat_area VALUES (49,'130127','高邑县','130100'); INSERT INTO hat_area VALUES (50,'130128','深泽县','130100'); INSERT INTO hat_area VALUES (51,'130129','赞皇县','130100'); INSERT INTO hat_area VALUES (52,'130130','无极县','130100'); INSERT INTO hat_area VALUES (53,'130131','平山县','130100'); INSERT INTO hat_area VALUES (54,'130132','元氏县','130100'); INSERT INTO hat_area VALUES (55,'130133','赵县','130100'); INSERT INTO hat_area VALUES (56,'130181','辛集市','130100'); INSERT INTO hat_area VALUES (57,'130182','藁城市','130100'); INSERT INTO hat_area VALUES (58,'130183','晋州市','130100'); INSERT INTO hat_area VALUES (59,'130184','新乐市','130100'); INSERT INTO hat_area VALUES (60,'130185','鹿泉市','130100');
INSERT INTO hat_area VALUES (62,'130202','路南区','130200'); INSERT INTO hat_area VALUES (63,'130203','路北区','130200'); INSERT INTO hat_area VALUES (64,'130204','古冶区','130200'); INSERT INTO hat_area VALUES (65,'130205','开平区','130200'); INSERT INTO hat_area VALUES (66,'130207','丰南区','130200'); INSERT INTO hat_area VALUES (67,'130208','丰润区','130200'); INSERT INTO hat_area VALUES (68,'130223','滦县','130200'); INSERT INTO hat_area VALUES (69,'130224','滦南县','130200'); INSERT INTO hat_area VALUES (70,'130225','乐亭县','130200'); INSERT INTO hat_area VALUES (71,'130227','迁西县','130200'); INSERT INTO hat_area VALUES (72,'130229','玉田县','130200'); INSERT INTO hat_area VALUES (73,'130230','唐海县','130200'); INSERT INTO hat_area VALUES (74,'130281','遵化市','130200'); INSERT INTO hat_area VALUES (75,'130283','迁安市','130200'); INSERT INTO hat_area VALUES (76,'130301','市辖区','130300'); INSERT INTO hat_area VALUES (77,'130302','海港区','130300'); INSERT INTO hat_area VALUES (78,'130303','山海关区','130300'); INSERT INTO hat_area VALUES (79,'130304','北戴河区','130300'); INSERT INTO hat_area VALUES (80,'130321','青龙满族自治县','130300'); INSERT INTO hat_area VALUES (81,'130322','昌黎县','130300'); INSERT INTO hat_area VALUES (82,'130323','抚宁县','130300'); INSERT INTO hat_area VALUES (83,'130324','卢龙县','130300'); INSERT INTO hat_area VALUES (84,'130401','市辖区','130400'); INSERT INTO hat_area VALUES (85,'130402','邯山区','130400'); INSERT INTO hat_area VALUES (86,'130403','丛台区','130400'); INSERT INTO hat_area VALUES (87,'130404','复兴区','130400'); INSERT INTO hat_area VALUES (88,'130406','峰峰矿区','130400'); INSERT INTO hat_area VALUES (89,'130421','邯郸县','130400'); INSERT INTO hat_area VALUES (90,'130423','临漳县','130400'); INSERT INTO hat_area VALUES (91,'130424','成安县','130400'); INSERT INTO hat_area VALUES (92,'130425','大名县','130400'); INSERT INTO hat_area VALUES (93,'130426','涉县','130400'); INSERT INTO hat_area VALUES (94,'130427','磁县','130400'); INSERT INTO hat_area VALUES (95,'130428','肥乡县','130400'); INSERT INTO hat_area VALUES (96,'130429','永年县','130400'); INSERT INTO hat_area VALUES (97,'130430','邱县','130400'); INSERT INTO hat_area VALUES (98,'130431','鸡泽县','130400'); INSERT INTO hat_area VALUES (99,'130432','广平县','130400'); INSERT INTO hat_area VALUES (100,'130433','馆陶县','130400'); INSERT INTO hat_area VALUES (101,'130434','魏县','130400'); INSERT INTO hat_area VALUES (102,'130435','曲周县','130400'); INSERT INTO hat_area VALUES (103,'130481','武安市','130400'); INSERT INTO hat_area VALUES (104,'130501','市辖区','130500');
INSERT INTO hat_area VALUES (106,'130503','桥西区','130500'); INSERT INTO hat_area VALUES (107,'130521','邢台县','130500'); INSERT INTO hat_area VALUES (108,'130522','临城县','130500'); INSERT INTO hat_area VALUES (109,'130523','内丘县','130500'); INSERT INTO hat_area VALUES (110,'130524','柏乡县','130500'); INSERT INTO hat_area VALUES (111,'130525','隆尧县','130500'); INSERT INTO hat_area VALUES (112,'130526','任县','130500'); INSERT INTO hat_area VALUES (113,'130527','南和县','130500'); INSERT INTO hat_area VALUES (114,'130528','宁晋县','130500'); INSERT INTO hat_area VALUES (115,'130529','巨鹿县','130500'); INSERT INTO hat_area VALUES (116,'130530','新河县','130500'); INSERT INTO hat_area VALUES (117,'130531','广宗县','130500'); INSERT INTO hat_area VALUES (118,'130532','平乡县','130500'); INSERT INTO hat_area VALUES (119,'130533','威县','130500'); INSERT INTO hat_area VALUES (120,'130534','清河县','130500'); INSERT INTO hat_area VALUES (121,'130535','临西县','130500'); INSERT INTO hat_area VALUES (122,'130581','南宫市','130500'); INSERT INTO hat_area VALUES (123,'130582','沙河市','130500'); INSERT INTO hat_area VALUES (124,'130601','市辖区','130600'); INSERT INTO hat_area VALUES (125,'130602','新市区','130600'); INSERT INTO hat_area VALUES (126,'130603','北市区','130600'); INSERT INTO hat_area VALUES (127,'130604','南市区','130600'); INSERT INTO hat_area VALUES (128,'130621','满城县','130600'); INSERT INTO hat_area VALUES (129,'130622','清苑县','130600'); INSERT INTO hat_area VALUES (130,'130623','涞水县','130600'); INSERT INTO hat_area VALUES (131,'130624','阜平县','130600'); INSERT INTO hat_area VALUES (132,'130625','徐水县','130600'); INSERT INTO hat_area VALUES (133,'130626','定兴县','130600'); INSERT INTO hat_area VALUES (134,'130627','唐县','130600'); INSERT INTO hat_area VALUES (135,'130628','高阳县','130600'); INSERT INTO hat_area VALUES (136,'130629','容城县','130600'); INSERT INTO hat_area VALUES (137,'130630','涞源县','130600'); INSERT INTO hat_area VALUES (138,'130631','望都县','130600'); INSERT INTO hat_area VALUES (139,'130632','安新县','130600'); INSERT INTO hat_area VALUES (140,'130633','易县','130600'); INSERT INTO hat_area VALUES (141,'130634','曲阳县','130600'); INSERT INTO hat_area VALUES (142,'130635','蠡县','130600'); INSERT INTO hat_area VALUES (143,'130636','顺平县','130600'); INSERT INTO hat_area VALUES (144,'130637','博野县','130600'); INSERT INTO hat_area VALUES (145,'130638','雄县','130600'); INSERT INTO hat_area VALUES (146,'130681','涿州市','130600'); INSERT INTO hat_area VALUES (147,'130682','定州市','130600'); INSERT INTO hat_area VALUES (148,'130683','安国市','130600');
INSERT INTO hat_area VALUES (150,'130701','市辖区','130700');
INSERT INTO hat_area VALUES (151,'130702','桥东区','130700');
INSERT INTO hat_area VALUES (152,'130703','桥西区','130700');
INSERT INTO hat_area VALUES (153,'130705','宣化区','130700');
INSERT INTO hat_area VALUES (154,'130706','下花园区','130700');
INSERT INTO hat_area VALUES (155,'130721','宣化县','130700');
INSERT INTO hat_area VALUES (156,'130722','张北县','130700');
INSERT INTO hat_area VALUES (157,'130723','康保县','130700');
INSERT INTO hat_area VALUES (158,'130724','沽源县','130700');
INSERT INTO hat_area VALUES (159,'130725','尚义县','130700');
INSERT INTO hat_area VALUES (160,'130726','蔚县','130700');
INSERT INTO hat_area VALUES (161,'130727','阳原县','130700');
INSERT INTO hat_area VALUES (162,'130728','怀安县','130700');
INSERT INTO hat_area VALUES (163,'130729','万全县','130700');
INSERT INTO hat_area VALUES (164,'130730','怀来县','130700');
INSERT INTO hat_area VALUES (165,'130731','涿鹿县','130700');
INSERT INTO hat_area VALUES (166,'130732','赤城县','130700');
INSERT INTO hat_area VALUES (167,'130733','崇礼县','130700');
INSERT INTO hat_area VALUES (168,'130801','市辖区','130800');
INSERT INTO hat_area VALUES (169,'130802','双桥区','130800');
INSERT INTO hat_area VALUES (170,'130803','双滦区','130800');
INSERT INTO hat_area VALUES (171,'130804','鹰手营子矿区','130800'); INSERT INTO hat_area VALUES (172,'130821','承德县','130800');
INSERT INTO hat_area VALUES (173,'130822','兴隆县','130800');
INSERT INTO hat_area VALUES (174,'130823','平泉县','130800');
INSERT INTO hat_area VALUES (175,'130824','滦平县','130800');
INSERT INTO hat_area VALUES (176,'130825','隆化县','130800');
INSERT INTO hat_area VALUES (177,'130826','丰宁满族自治县','130800'); INSERT INTO hat_area VALUES (178,'130827','宽城满族自治县','130800'); INSERT INTO hat_area VALUES (179,'130828','围场满族蒙古族自治县','130800'); INSERT INTO hat_area VALUES (180,'130901','市辖区','130900');
INSERT INTO hat_area VALUES (181,'130902','新华区','130900');
INSERT INTO hat_area VALUES (182,'130903','运河区','130900');
INSERT INTO hat_area VALUES (183,'130921','沧县','130900');
INSERT INTO hat_area VALUES (184,'130922','青县','130900');
INSERT INTO hat_area VALUES (185,'130923','东光县','130900');
INSERT INTO hat_area VALUES (186,'130924','海兴县','130900');
INSERT INTO hat_area VALUES (187,'130925','盐山县','130900');
INSERT INTO hat_area VALUES (188,'130926','肃宁县','130900');
INSERT INTO hat_area VALUES (189,'130927','南皮县','130900');
INSERT INTO hat_area VALUES (190,'130928','吴桥县','130900');
INSERT INTO hat_area VALUES (191,'130929','献县','130900');
INSERT INTO hat_area VALUES (192,'130930','孟村回族自治县','130900');
INSERT INTO hat_area VALUES (194,'130982','任丘市','130900'); INSERT INTO hat_area VALUES (195,'130983','黄骅市','130900'); INSERT INTO hat_area VALUES (196,'130984','河间市','130900'); INSERT INTO hat_area VALUES (197,'131001','市辖区','131000'); INSERT INTO hat_area VALUES (198,'131002','安次区','131000'); INSERT INTO hat_area VALUES (199,'131003','广阳区','131000'); INSERT INTO hat_area VALUES (200,'131022','固安县','131000'); INSERT INTO hat_area VALUES (201,'131023','永清县','131000'); INSERT INTO hat_area VALUES (202,'131024','香河县','131000'); INSERT INTO hat_area VALUES (203,'131025','大城县','131000'); INSERT INTO hat_area VALUES (204,'131026','文安县','131000'); INSERT INTO hat_area VALUES (205,'131028','大厂回族自治县','131000'); INSERT INTO hat_area VALUES (206,'131081','霸州市','131000'); INSERT INTO hat_area VALUES (207,'131082','三河市','131000'); INSERT INTO hat_area VALUES (208,'131101','市辖区','131100'); INSERT INTO hat_area VALUES (209,'131102','桃城区','131100'); INSERT INTO hat_area VALUES (210,'131121','枣强县','131100'); INSERT INTO hat_area VALUES (211,'131122','武邑县','131100'); INSERT INTO hat_area VALUES (212,'131123','武强县','131100'); INSERT INTO hat_area VALUES (213,'131124','饶阳县','131100'); INSERT INTO hat_area VALUES (214,'131125','安平县','131100'); INSERT INTO hat_area VALUES (215,'131126','故城县','131100'); INSERT INTO hat_area VALUES (216,'131127','景县','131100'); INSERT INTO hat_area VALUES (217,'131128','阜城县','131100'); INSERT INTO hat_area VALUES (218,'131181','冀州市','131100'); INSERT INTO hat_area VALUES (219,'131182','深州市','131100'); INSERT INTO hat_area VALUES (220,'140101','市辖区','140100'); INSERT INTO hat_area VALUES (221,'140105','小店区','140100'); INSERT INTO hat_area VALUES (222,'140106','迎泽区','140100'); INSERT INTO hat_area VALUES (223,'140107','杏花岭区','140100'); INSERT INTO hat_area VALUES (224,'140108','尖草坪区','140100'); INSERT INTO hat_area VALUES (225,'140109','万柏林区','140100'); INSERT INTO hat_area VALUES (226,'140110','晋源区','140100'); INSERT INTO hat_area VALUES (227,'140121','清徐县','140100'); INSERT INTO hat_area VALUES (228,'140122','阳曲县','140100'); INSERT INTO hat_area VALUES (229,'140123','娄烦县','140100'); INSERT INTO hat_area VALUES (230,'140181','古交市','140100'); INSERT INTO hat_area VALUES (231,'140201','市辖区','140200'); INSERT INTO hat_area VALUES (232,'140202','城区','140200'); INSERT INTO hat_area VALUES (233,'140203','矿区','140200'); INSERT INTO hat_area VALUES (234,'140211','南郊区','140200'); INSERT INTO hat_area VALUES (235,'140212','新荣区','140200'); INSERT INTO hat_area VALUES (236,'140221','阳高县','140200');
INSERT INTO hat_area VALUES (238,'140223','广灵县','140200'); INSERT INTO hat_area VALUES (239,'140224','灵丘县','140200'); INSERT INTO hat_area VALUES (240,'140225','浑源县','140200'); INSERT INTO hat_area VALUES (241,'140226','左云县','140200'); INSERT INTO hat_area VALUES (242,'140227','大同县','140200'); INSERT INTO hat_area VALUES (243,'140301','市辖区','140300'); INSERT INTO hat_area VALUES (244,'140302','城区','140300'); INSERT INTO hat_area VALUES (245,'140303','矿区','140300'); INSERT INTO hat_area VALUES (246,'140311','郊区','140300'); INSERT INTO hat_area VALUES (247,'140321','平定县','140300'); INSERT INTO hat_area VALUES (248,'140322','盂县','140300'); INSERT INTO hat_area VALUES (249,'140401','市辖区','140400'); INSERT INTO hat_area VALUES (250,'140402','城区','140400'); INSERT INTO hat_area VALUES (251,'140411','郊区','140400'); INSERT INTO hat_area VALUES (252,'140421','长治县','140400'); INSERT INTO hat_area VALUES (253,'140423','襄垣县','140400'); INSERT INTO hat_area VALUES (254,'140424','屯留县','140400'); INSERT INTO hat_area VALUES (255,'140425','平顺县','140400'); INSERT INTO hat_area VALUES (256,'140426','黎城县','140400'); INSERT INTO hat_area VALUES (257,'140427','壶关县','140400'); INSERT INTO hat_area VALUES (258,'140428','长子县','140400'); INSERT INTO hat_area VALUES (259,'140429','武乡县','140400'); INSERT INTO hat_area VALUES (260,'140430','沁县','140400'); INSERT INTO hat_area VALUES (261,'140431','沁源县','140400'); INSERT INTO hat_area VALUES (262,'140481','潞城市','140400'); INSERT INTO hat_area VALUES (263,'140501','市辖区','140500'); INSERT INTO hat_area VALUES (264,'140502','城区','140500'); INSERT INTO hat_area VALUES (265,'140521','沁水县','140500'); INSERT INTO hat_area VALUES (266,'140522','阳城县','140500'); INSERT INTO hat_area VALUES (267,'140524','陵川县','140500'); INSERT INTO hat_area VALUES (268,'140525','泽州县','140500'); INSERT INTO hat_area VALUES (269,'140581','高平市','140500'); INSERT INTO hat_area VALUES (270,'140601','市辖区','140600'); INSERT INTO hat_area VALUES (271,'140602','朔城区','140600'); INSERT INTO hat_area VALUES (272,'140603','平鲁区','140600'); INSERT INTO hat_area VALUES (273,'140621','山阴县','140600'); INSERT INTO hat_area VALUES (274,'140622','应县','140600'); INSERT INTO hat_area VALUES (275,'140623','右玉县','140600'); INSERT INTO hat_area VALUES (276,'140624','怀仁县','140600'); INSERT INTO hat_area VALUES (277,'140701','市辖区','140700'); INSERT INTO hat_area VALUES (278,'140702','榆次区','140700'); INSERT INTO hat_area VALUES (279,'140721','榆社县','140700'); INSERT INTO hat_area VALUES (280,'140722','左权县','140700');
INSERT INTO hat_area VALUES (282,'140724','昔阳县','140700'); INSERT INTO hat_area VALUES (283,'140725','寿阳县','140700'); INSERT INTO hat_area VALUES (284,'140726','太谷县','140700'); INSERT INTO hat_area VALUES (285,'140727','祁县','140700'); INSERT INTO hat_area VALUES (286,'140728','平遥县','140700'); INSERT INTO hat_area VALUES (287,'140729','灵石县','140700'); INSERT INTO hat_area VALUES (288,'140781','介休市','140700'); INSERT INTO hat_area VALUES (289,'140801','市辖区','140800'); INSERT INTO hat_area VALUES (290,'140802','盐湖区','140800'); INSERT INTO hat_area VALUES (291,'140821','临猗县','140800'); INSERT INTO hat_area VALUES (292,'140822','万荣县','140800'); INSERT INTO hat_area VALUES (293,'140823','闻喜县','140800'); INSERT INTO hat_area VALUES (294,'140824','稷山县','140800'); INSERT INTO hat_area VALUES (295,'140825','新绛县','140800'); INSERT INTO hat_area VALUES (296,'140826','绛县','140800'); INSERT INTO hat_area VALUES (297,'140827','垣曲县','140800'); INSERT INTO hat_area VALUES (298,'140828','夏县','140800'); INSERT INTO hat_area VALUES (299,'140829','平陆县','140800'); INSERT INTO hat_area VALUES (300,'140830','芮城县','140800'); INSERT INTO hat_area VALUES (301,'140881','永济市','140800'); INSERT INTO hat_area VALUES (302,'140882','河津市','140800'); INSERT INTO hat_area VALUES (303,'140901','市辖区','140900'); INSERT INTO hat_area VALUES (304,'140902','忻府区','140900'); INSERT INTO hat_area VALUES (305,'140921','定襄县','140900'); INSERT INTO hat_area VALUES (306,'140922','五台县','140900'); INSERT INTO hat_area VALUES (307,'140923','代县','140900'); INSERT INTO hat_area VALUES (308,'140924','繁峙县','140900'); INSERT INTO hat_area VALUES (309,'140925','宁武县','140900'); INSERT INTO hat_area VALUES (310,'140926','静乐县','140900'); INSERT INTO hat_area VALUES (311,'140927','神池县','140900'); INSERT INTO hat_area VALUES (312,'140928','五寨县','140900'); INSERT INTO hat_area VALUES (313,'140929','岢岚县','140900'); INSERT INTO hat_area VALUES (314,'140930','河曲县','140900'); INSERT INTO hat_area VALUES (315,'140931','保德县','140900'); INSERT INTO hat_area VALUES (316,'140932','偏关县','140900'); INSERT INTO hat_area VALUES (317,'140981','原平市','140900'); INSERT INTO hat_area VALUES (318,'141001','市辖区','141000'); INSERT INTO hat_area VALUES (319,'141002','尧都区','141000'); INSERT INTO hat_area VALUES (320,'141021','曲沃县','141000'); INSERT INTO hat_area VALUES (321,'141022','翼城县','141000'); INSERT INTO hat_area VALUES (322,'141023','襄汾县','141000'); INSERT INTO hat_area VALUES (323,'141024','洪洞县','141000'); INSERT INTO hat_area VALUES (324,'141025','古县','141000');
INSERT INTO hat_area VALUES (326,'141027','浮山县','141000'); INSERT INTO hat_area VALUES (327,'141028','吉县','141000'); INSERT INTO hat_area VALUES (328,'141029','乡宁县','141000'); INSERT INTO hat_area VALUES (329,'141030','大宁县','141000'); INSERT INTO hat_area VALUES (330,'141031','隰县','141000'); INSERT INTO hat_area VALUES (331,'141032','永和县','141000'); INSERT INTO hat_area VALUES (332,'141033','蒲县','141000'); INSERT INTO hat_area VALUES (333,'141034','汾西县','141000'); INSERT INTO hat_area VALUES (334,'141081','侯马市','141000'); INSERT INTO hat_area VALUES (335,'141082','霍州市','141000'); INSERT INTO hat_area VALUES (336,'141101','市辖区','141100'); INSERT INTO hat_area VALUES (337,'141102','离石区','141100'); INSERT INTO hat_area VALUES (338,'141121','文水县','141100'); INSERT INTO hat_area VALUES (339,'141122','交城县','141100'); INSERT INTO hat_area VALUES (340,'141123','兴县','141100'); INSERT INTO hat_area VALUES (341,'141124','临县','141100'); INSERT INTO hat_area VALUES (342,'141125','柳林县','141100'); INSERT INTO hat_area VALUES (343,'141126','石楼县','141100'); INSERT INTO hat_area VALUES (344,'141127','岚县','141100'); INSERT INTO hat_area VALUES (345,'141128','方山县','141100'); INSERT INTO hat_area VALUES (346,'141129','中阳县','141100'); INSERT INTO hat_area VALUES (347,'141130','交口县','141100'); INSERT INTO hat_area VALUES (348,'141181','孝义市','141100'); INSERT INTO hat_area VALUES (349,'141182','汾阳市','141100'); INSERT INTO hat_area VALUES (350,'150101','市辖区','150100'); INSERT INTO hat_area VALUES (351,'150102','新城区','150100'); INSERT INTO hat_area VALUES (352,'150103','回民区','150100'); INSERT INTO hat_area VALUES (353,'150104','玉泉区','150100'); INSERT INTO hat_area VALUES (354,'150105','赛罕区','150100'); INSERT INTO hat_area VALUES (355,'150121','土默特左旗','150100'); INSERT INTO hat_area VALUES (356,'150122','托克托县','150100'); INSERT INTO hat_area VALUES (357,'150123','和林格尔县','150100'); INSERT INTO hat_area VALUES (358,'150124','清水河县','150100'); INSERT INTO hat_area VALUES (359,'150125','武川县','150100'); INSERT INTO hat_area VALUES (360,'150201','市辖区','150200'); INSERT INTO hat_area VALUES (361,'150202','东河区','150200'); INSERT INTO hat_area VALUES (362,'150203','昆都仑区','150200'); INSERT INTO hat_area VALUES (363,'150204','青山区','150200'); INSERT INTO hat_area VALUES (364,'150205','石拐区','150200'); INSERT INTO hat_area VALUES (365,'150206','白云矿区','150200'); INSERT INTO hat_area VALUES (366,'150207','九原区','150200'); INSERT INTO hat_area VALUES (367,'150221','土默特右旗','150200'); INSERT INTO hat_area VALUES (368,'150222','固阳县','150200');
INSERT INTO hat_area VALUES (369,'150223','达尔罕茂明安联合旗','150200'); INSERT INTO hat_area VALUES (370,'150301','市辖区','150300');
INSERT INTO hat_area VALUES (371,'150302','海勃湾区','150300');
INSERT INTO hat_area VALUES (372,'150303','海南区','150300');
INSERT INTO hat_area VALUES (373,'150304','乌达区','150300');
INSERT INTO hat_area VALUES (374,'150401','市辖区','150400');
INSERT INTO hat_area VALUES (375,'150402','红山区','150400');
INSERT INTO hat_area VALUES (376,'150403','元宝山区','150400');
INSERT INTO hat_area VALUES (377,'150404','松山区','150400');
INSERT INTO hat_area VALUES (378,'150421','阿鲁科尔沁旗','150400');
INSERT INTO hat_area VALUES (379,'150422','巴林左旗','150400');
INSERT INTO hat_area VALUES (380,'150423','巴林右旗','150400');
INSERT INTO hat_area VALUES (381,'150424','林西县','150400');
INSERT INTO hat_area VALUES (382,'150425','克什克腾旗','150400');
INSERT INTO hat_area VALUES (383,'150426','翁牛特旗','150400');
INSERT INTO hat_area VALUES (384,'150428','喀喇沁旗','150400');
INSERT INTO hat_area VALUES (385,'150429','宁城县','150400');
INSERT INTO hat_area VALUES (386,'150430','敖汉旗','150400');
INSERT INTO hat_area VALUES (387,'150501','市辖区','150500');
INSERT INTO hat_area VALUES (388,'150502','科尔沁区','150500');
INSERT INTO hat_area VALUES (389,'150521','科尔沁左翼中旗','150500'); INSERT INTO hat_area VALUES (390,'150522','科尔沁左翼后旗','150500'); INSERT INTO hat_area VALUES (391,'150523','开鲁县','150500');
INSERT INTO hat_area VALUES (392,'150524','库伦旗','150500');
INSERT INTO hat_area VALUES (393,'150525','奈曼旗','150500');
INSERT INTO hat_area VALUES (394,'150526','扎鲁特旗','150500');
INSERT INTO hat_area VALUES (395,'150581','霍林郭勒市','150500');
INSERT INTO hat_area VALUES (396,'150602','东胜区','150600');
INSERT INTO hat_area VALUES (397,'150621','达拉特旗','150600');
INSERT INTO hat_area VALUES (398,'150622','准格尔旗','150600');
INSERT INTO hat_area VALUES (399,'150623','鄂托克前旗','150600');
INSERT INTO hat_area VALUES (400,'150624','鄂托克旗','150600');
INSERT INTO hat_area VALUES (401,'150625','杭锦旗','150600');
INSERT INTO hat_area VALUES (402,'150626','乌审旗','150600');
INSERT INTO hat_area VALUES (403,'150627','伊金霍洛旗','150600');
INSERT INTO hat_area VALUES (404,'150701','市辖区','150700');
INSERT INTO hat_area VALUES (405,'150702','海拉尔区','150700');
INSERT INTO hat_area VALUES (406,'150721','阿荣旗','150700');
INSERT INTO hat_area VALUES (407,'150722','莫力达瓦达斡尔族自治旗','150700'); INSERT INTO hat_area VALUES (408,'150723','鄂伦春自治旗','150700');
INSERT INTO hat_area VALUES (409,'150724','鄂温克族自治旗','150700'); INSERT INTO hat_area VALUES (410,'150725','陈巴尔虎旗','150700');
INSERT INTO hat_area VALUES (411,'150726','新巴尔虎左旗','150700');
INSERT INTO hat_area VALUES (412,'150727','新巴尔虎右旗','150700');
INSERT INTO hat_area VALUES (413,'150781','满洲里市','150700'); INSERT INTO hat_area VALUES (414,'150782','牙克石市','150700'); INSERT INTO hat_area VALUES (415,'150783','扎兰屯市','150700'); INSERT INTO hat_area VALUES (416,'150784','额尔古纳市','150700'); INSERT INTO hat_area VALUES (417,'150785','根河市','150700'); INSERT INTO hat_area VALUES (418,'150801','市辖区','150800'); INSERT INTO hat_area VALUES (419,'150802','临河区','150800'); INSERT INTO hat_area VALUES (420,'150821','五原县','150800'); INSERT INTO hat_area VALUES (421,'150822','磴口县','150800'); INSERT INTO hat_area VALUES (422,'150823','乌拉特前旗','150800'); INSERT INTO hat_area VALUES (423,'150824','乌拉特中旗','150800'); INSERT INTO hat_area VALUES (424,'150825','乌拉特后旗','150800'); INSERT INTO hat_area VALUES (425,'150826','杭锦后旗','150800'); INSERT INTO hat_area VALUES (426,'150901','市辖区','150900'); INSERT INTO hat_area VALUES (427,'150902','集宁区','150900'); INSERT INTO hat_area VALUES (428,'150921','卓资县','150900'); INSERT INTO hat_area VALUES (429,'150922','化德县','150900'); INSERT INTO hat_area VALUES (430,'150923','商都县','150900'); INSERT INTO hat_area VALUES (431,'150924','兴和县','150900'); INSERT INTO hat_area VALUES (432,'150925','凉城县','150900'); INSERT INTO hat_area VALUES (433,'150926','察哈尔右翼前旗','150900'); INSERT INTO hat_area VALUES (434,'150927','察哈尔右翼中旗','150900'); INSERT INTO hat_area VALUES (435,'150928','察哈尔右翼后旗','150900'); INSERT INTO hat_area VALUES (436,'150929','四子王旗','150900'); INSERT INTO hat_area VALUES (437,'150981','丰镇市','150900'); INSERT INTO hat_area VALUES (438,'152201','乌兰浩特市','152200'); INSERT INTO hat_area VALUES (439,'152202','阿尔山市','152200'); INSERT INTO hat_area VALUES (440,'152221','科尔沁右翼前旗','152200'); INSERT INTO hat_area VALUES (441,'152222','科尔沁右翼中旗','152200'); INSERT INTO hat_area VALUES (442,'152223','扎赉特旗','152200'); INSERT INTO hat_area VALUES (443,'152224','突泉县','152200'); INSERT INTO hat_area VALUES (444,'152501','二连浩特市','152500'); INSERT INTO hat_area VALUES (445,'152502','锡林浩特市','152500'); INSERT INTO hat_area VALUES (446,'152522','阿巴嘎旗','152500'); INSERT INTO hat_area VALUES (447,'152523','苏尼特左旗','152500'); INSERT INTO hat_area VALUES (448,'152524','苏尼特右旗','152500'); INSERT INTO hat_area VALUES (449,'152525','东乌珠穆沁旗','152500'); INSERT INTO hat_area VALUES (450,'152526','西乌珠穆沁旗','152500'); INSERT INTO hat_area VALUES (451,'152527','太仆寺旗','152500'); INSERT INTO hat_area VALUES (452,'152528','镶黄旗','152500'); INSERT INTO hat_area VALUES (453,'152529','正镶白旗','152500'); INSERT INTO hat_area VALUES (454,'152530','正蓝旗','152500'); INSERT INTO hat_area VALUES (455,'152531','多伦县','152500'); INSERT INTO hat_area VALUES (456,'152921','阿拉善左旗','152900');
INSERT INTO hat_area VALUES (457,'152922','阿拉善右旗','152900'); INSERT INTO hat_area VALUES (458,'152923','额济纳旗','152900'); INSERT INTO hat_area VALUES (459,'210101','市辖区','210100'); INSERT INTO hat_area VALUES (460,'210102','和平区','210100'); INSERT INTO hat_area VALUES (461,'210103','沈河区','210100'); INSERT INTO hat_area VALUES (462,'210104','大东区','210100'); INSERT INTO hat_area VALUES (463,'210105','皇姑区','210100'); INSERT INTO hat_area VALUES (464,'210106','铁西区','210100'); INSERT INTO hat_area VALUES (465,'210111','苏家屯区','210100'); INSERT INTO hat_area VALUES (466,'210112','东陵区','210100'); INSERT INTO hat_area VALUES (467,'210113','新城子区','210100'); INSERT INTO hat_area VALUES (468,'210114','于洪区','210100'); INSERT INTO hat_area VALUES (469,'210122','辽中县','210100'); INSERT INTO hat_area VALUES (470,'210123','康平县','210100'); INSERT INTO hat_area VALUES (471,'210124','法库县','210100'); INSERT INTO hat_area VALUES (472,'210181','新民市','210100'); INSERT INTO hat_area VALUES (473,'210201','市辖区','210200'); INSERT INTO hat_area VALUES (474,'210202','中山区','210200'); INSERT INTO hat_area VALUES (475,'210203','西岗区','210200'); INSERT INTO hat_area VALUES (476,'210204','沙河口区','210200'); INSERT INTO hat_area VALUES (477,'210211','甘井子区','210200'); INSERT INTO hat_area VALUES (478,'210212','旅顺口区','210200'); INSERT INTO hat_area VALUES (479,'210213','金州区','210200'); INSERT INTO hat_area VALUES (480,'210224','长海县','210200'); INSERT INTO hat_area VALUES (481,'210281','瓦房店市','210200'); INSERT INTO hat_area VALUES (482,'210282','普兰店市','210200'); INSERT INTO hat_area VALUES (483,'210283','庄河市','210200'); INSERT INTO hat_area VALUES (484,'210301','市辖区','210300'); INSERT INTO hat_area VALUES (485,'210302','铁东区','210300'); INSERT INTO hat_area VALUES (486,'210303','铁西区','210300'); INSERT INTO hat_area VALUES (487,'210304','立山区','210300'); INSERT INTO hat_area VALUES (488,'210311','千山区','210300'); INSERT INTO hat_area VALUES (489,'210321','台安县','210300'); INSERT INTO hat_area VALUES (490,'210323','岫岩满族自治县','210300'); INSERT INTO hat_area VALUES (491,'210381','海城市','210300'); INSERT INTO hat_area VALUES (492,'210401','市辖区','210400'); INSERT INTO hat_area VALUES (493,'210402','新抚区','210400'); INSERT INTO hat_area VALUES (494,'210403','东洲区','210400'); INSERT INTO hat_area VALUES (495,'210404','望花区','210400'); INSERT INTO hat_area VALUES (496,'210411','顺城区','210400'); INSERT INTO hat_area VALUES (497,'210421','抚顺县','210400'); INSERT INTO hat_area VALUES (498,'210422','新宾满族自治县','210400'); INSERT INTO hat_area VALUES (499,'210423','清原满族自治县','210400'); INSERT INTO hat_area VALUES (500,'210501','市辖区','210500');
INSERT INTO hat_area VALUES (502,'210503','溪湖区','210500');
INSERT INTO hat_area VALUES (503,'210504','明山区','210500');
INSERT INTO hat_area VALUES (504,'210505','南芬区','210500');
INSERT INTO hat_area VALUES (505,'210521','本溪满族自治县','210500'); INSERT INTO hat_area VALUES (506,'210522','桓仁满族自治县','210500'); INSERT INTO hat_area VALUES (507,'210601','市辖区','210600');
INSERT INTO hat_area VALUES (508,'210602','元宝区','210600');
INSERT INTO hat_area VALUES (509,'210603','振兴区','210600');
INSERT INTO hat_area VALUES (510,'210604','振安区','210600');
INSERT INTO hat_area VALUES (511,'210624','宽甸满族自治县','210600'); INSERT INTO hat_area VALUES (512,'210681','东港市','210600');
INSERT INTO hat_area VALUES (513,'210682','凤城市','210600');
INSERT INTO hat_area VALUES (514,'210701','市辖区','210700');
INSERT INTO hat_area VALUES (515,'210702','古塔区','210700');
INSERT INTO hat_area VALUES (516,'210703','凌河区','210700');
INSERT INTO hat_area VALUES (517,'210711','太和区','210700');
INSERT INTO hat_area VALUES (518,'210726','黑山县','210700');
INSERT INTO hat_area VALUES (519,'210727','义县','210700');
INSERT INTO hat_area VALUES (520,'210781','凌海市','210700');
INSERT INTO hat_area VALUES (521,'210782','北宁市','210700');
INSERT INTO hat_area VALUES (522,'210801','市辖区','210800');
INSERT INTO hat_area VALUES (523,'210802','站前区','210800');
INSERT INTO hat_area VALUES (524,'210803','西市区','210800');
INSERT INTO hat_area VALUES (525,'210804','鲅鱼圈区','210800'); INSERT INTO hat_area VALUES (526,'210811','老边区','210800');
INSERT INTO hat_area VALUES (527,'210881','盖州市','210800');
INSERT INTO hat_area VALUES (528,'210882','大石桥市','210800'); INSERT INTO hat_area VALUES (529,'210901','市辖区','210900');
INSERT INTO hat_area VALUES (530,'210902','海州区','210900');
INSERT INTO hat_area VALUES (531,'210903','新邱区','210900');
INSERT INTO hat_area VALUES (532,'210904','太平区','210900');
INSERT INTO hat_area VALUES (533,'210905','清河门区','210900'); INSERT INTO hat_area VALUES (534,'210911','细河区','210900');
INSERT INTO hat_area VALUES (535,'210921','阜新蒙古族自治县','210900'); INSERT INTO hat_area VALUES (536,'210922','彰武县','210900');
INSERT INTO hat_area VALUES (537,'211001','市辖区','211000');
INSERT INTO hat_area VALUES (538,'211002','白塔区','211000');
INSERT INTO hat_area VALUES (539,'211003','文圣区','211000');
INSERT INTO hat_area VALUES (540,'211004','宏伟区','211000');
INSERT INTO hat_area VALUES (541,'211005','弓长岭区','211000'); INSERT INTO hat_area VALUES (542,'211011','太子河区','211000'); INSERT INTO hat_area VALUES (543,'211021','辽阳县','211000');
INSERT INTO hat_area VALUES (544,'211081','灯塔市','211000');
INSERT INTO hat_area VALUES (546,'211102','双台子区','211100');
INSERT INTO hat_area VALUES (547,'211103','兴隆台区','211100');
INSERT INTO hat_area VALUES (548,'211121','大洼县','211100');
INSERT INTO hat_area VALUES (549,'211122','盘山县','211100');
INSERT INTO hat_area VALUES (550,'211201','市辖区','211200');
INSERT INTO hat_area VALUES (551,'211202','银州区','211200');
INSERT INTO hat_area VALUES (552,'211204','清河区','211200');
INSERT INTO hat_area VALUES (553,'211221','铁岭县','211200');
INSERT INTO hat_area VALUES (554,'211223','西丰县','211200');
INSERT INTO hat_area VALUES (555,'211224','昌图县','211200');
INSERT INTO hat_area VALUES (556,'211281','调兵山市','211200');
INSERT INTO hat_area VALUES (557,'211282','开原市','211200');
INSERT INTO hat_area VALUES (558,'211301','市辖区','211300');
INSERT INTO hat_area VALUES (559,'211302','双塔区','211300');
INSERT INTO hat_area VALUES (560,'211303','龙城区','211300');
INSERT INTO hat_area VALUES (561,'211321','朝阳县','211300');
INSERT INTO hat_area VALUES (562,'211322','建平县','211300');
INSERT INTO hat_area VALUES (563,'211324','喀喇沁左翼蒙古族自治县','211300'); INSERT INTO hat_area VALUES (564,'211381','北票市','211300');
INSERT INTO hat_area VALUES (565,'211382','凌源市','211300');
INSERT INTO hat_area VALUES (566,'211401','市辖区','211400');
INSERT INTO hat_area VALUES (567,'211402','连山区','211400');
INSERT INTO hat_area VALUES (568,'211403','龙港区','211400');
INSERT INTO hat_area VALUES (569,'211404','南票区','211400');
INSERT INTO hat_area VALUES (570,'211421','绥中县','211400');
INSERT INTO hat_area VALUES (571,'211422','建昌县','211400');
INSERT INTO hat_area VALUES (572,'211481','兴城市','211400');
INSERT INTO hat_area VALUES (573,'220101','市辖区','220100');
INSERT INTO hat_area VALUES (574,'220102','南关区','220100');
INSERT INTO hat_area VALUES (575,'220103','宽城区','220100');
INSERT INTO hat_area VALUES (576,'220104','朝阳区','220100');
INSERT INTO hat_area VALUES (577,'220105','二道区','220100');
INSERT INTO hat_area VALUES (578,'220106','绿园区','220100');
INSERT INTO hat_area VALUES (579,'220112','双阳区','220100');
INSERT INTO hat_area VALUES (580,'220122','农安县','220100');
INSERT INTO hat_area VALUES (581,'220181','九台市','220100');
INSERT INTO hat_area VALUES (582,'220182','榆树市','220100');
INSERT INTO hat_area VALUES (583,'220183','德惠市','220100');
INSERT INTO hat_area VALUES (584,'220201','市辖区','220200');
INSERT INTO hat_area VALUES (585,'220202','昌邑区','220200');
INSERT INTO hat_area VALUES (586,'220203','龙潭区','220200');
INSERT INTO hat_area VALUES (587,'220204','船营区','220200');
INSERT INTO hat_area VALUES (588,'220211','丰满区','220200');
INSERT INTO hat_area VALUES (590,'220281','蛟河市','220200');
INSERT INTO hat_area VALUES (591,'220282','桦甸市','220200');
INSERT INTO hat_area VALUES (592,'220283','舒兰市','220200');
INSERT INTO hat_area VALUES (593,'220284','磐石市','220200');
INSERT INTO hat_area VALUES (594,'220301','市辖区','220300');
INSERT INTO hat_area VALUES (595,'220302','铁西区','220300');
INSERT INTO hat_area VALUES (596,'220303','铁东区','220300');
INSERT INTO hat_area VALUES (597,'220322','梨树县','220300');
INSERT INTO hat_area VALUES (598,'220323','伊通满族自治县','220300'); INSERT INTO hat_area VALUES (599,'220381','公主岭市','220300');
INSERT INTO hat_area VALUES (600,'220382','双辽市','220300');
INSERT INTO hat_area VALUES (601,'220401','市辖区','220400');
INSERT INTO hat_area VALUES (602,'220402','龙山区','220400');
INSERT INTO hat_area VALUES (603,'220403','西安区','220400');
INSERT INTO hat_area VALUES (604,'220421','东丰县','220400');
INSERT INTO hat_area VALUES (605,'220422','东辽县','220400');
INSERT INTO hat_area VALUES (606,'220501','市辖区','220500');
INSERT INTO hat_area VALUES (607,'220502','东昌区','220500');
INSERT INTO hat_area VALUES (608,'220503','二道江区','220500');
INSERT INTO hat_area VALUES (609,'220521','通化县','220500');
INSERT INTO hat_area VALUES (610,'220523','辉南县','220500');
INSERT INTO hat_area VALUES (611,'220524','柳河县','220500');
INSERT INTO hat_area VALUES (612,'220581','梅河口市','220500');
INSERT INTO hat_area VALUES (613,'220582','集安市','220500');
INSERT INTO hat_area VALUES (614,'220601','市辖区','220600');
INSERT INTO hat_area VALUES (615,'220602','八道江区','220600');
INSERT INTO hat_area VALUES (616,'220621','抚松县','220600');
INSERT INTO hat_area VALUES (617,'220622','靖宇县','220600');
INSERT INTO hat_area VALUES (618,'220623','长白朝鲜族自治县','220600'); INSERT INTO hat_area VALUES (619,'220625','江源县','220600');
INSERT INTO hat_area VALUES (620,'220681','临江市','220600');
INSERT INTO hat_area VALUES (621,'220701','市辖区','220700');
INSERT INTO hat_area VALUES (622,'220702','宁江区','220700');
INSERT INTO hat_area VALUES (623,'220721','前郭尔罗斯蒙古族自治县','220700'); INSERT INTO hat_area VALUES (624,'220722','长岭县','220700');
INSERT INTO hat_area VALUES (625,'220723','乾安县','220700');
INSERT INTO hat_area VALUES (626,'220724','扶余县','220700');
INSERT INTO hat_area VALUES (627,'220801','市辖区','220800');
INSERT INTO hat_area VALUES (628,'220802','洮北区','220800');
INSERT INTO hat_area VALUES (629,'220821','镇赉县','220800');
INSERT INTO hat_area VALUES (630,'220822','通榆县','220800');
INSERT INTO hat_area VALUES (631,'220881','洮南市','220800');
INSERT INTO hat_area VALUES (632,'220882','大安市','220800');
INSERT INTO hat_area VALUES (634,'222402','图们市','222400');
INSERT INTO hat_area VALUES (635,'222403','敦化市','222400');
INSERT INTO hat_area VALUES (636,'222404','珲春市','222400');
INSERT INTO hat_area VALUES (637,'222405','龙井市','222400');
INSERT INTO hat_area VALUES (638,'222406','和龙市','222400');
INSERT INTO hat_area VALUES (639,'222424','汪清县','222400');
INSERT INTO hat_area VALUES (640,'222426','安图县','222400');
INSERT INTO hat_area VALUES (641,'230101','市辖区','230100');
INSERT INTO hat_area VALUES (642,'230102','道里区','230100');
INSERT INTO hat_area VALUES (643,'230103','南岗区','230100');
INSERT INTO hat_area VALUES (644,'230104','道外区','230100');
INSERT INTO hat_area VALUES (645,'230106','香坊区','230100');
INSERT INTO hat_area VALUES (646,'230107','动力区','230100');
INSERT INTO hat_area VALUES (647,'230108','平房区','230100');
INSERT INTO hat_area VALUES (648,'230109','松北区','230100');
INSERT INTO hat_area VALUES (649,'230111','呼兰区','230100');
INSERT INTO hat_area VALUES (650,'230123','依兰县','230100');
INSERT INTO hat_area VALUES (651,'230124','方正县','230100');
INSERT INTO hat_area VALUES (652,'230125','宾县','230100');
INSERT INTO hat_area VALUES (653,'230126','巴彦县','230100');
INSERT INTO hat_area VALUES (654,'230127','木兰县','230100');
INSERT INTO hat_area VALUES (655,'230128','通河县','230100');
INSERT INTO hat_area VALUES (656,'230129','延寿县','230100');
INSERT INTO hat_area VALUES (657,'230181','阿城市','230100');
INSERT INTO hat_area VALUES (658,'230182','双城市','230100');
INSERT INTO hat_area VALUES (659,'230183','尚志市','230100');
INSERT INTO hat_area VALUES (660,'230184','五常市','230100');
INSERT INTO hat_area VALUES (661,'230201','市辖区','230200');
INSERT INTO hat_area VALUES (662,'230202','龙沙区','230200');
INSERT INTO hat_area VALUES (663,'230203','建华区','230200');
INSERT INTO hat_area VALUES (664,'230204','铁锋区','230200');
INSERT INTO hat_area VALUES (665,'230205','昂昂溪区','230200'); INSERT INTO hat_area VALUES (666,'230206','富拉尔基区','230200'); INSERT INTO hat_area VALUES (667,'230207','碾子山区','230200'); INSERT INTO hat_area VALUES (668,'230208','梅里斯达斡尔族区','230200'); INSERT INTO hat_area VALUES (669,'230221','龙江县','230200');
INSERT INTO hat_area VALUES (670,'230223','依安县','230200');
INSERT INTO hat_area VALUES (671,'230224','泰来县','230200');
INSERT INTO hat_area VALUES (672,'230225','甘南县','230200');
INSERT INTO hat_area VALUES (673,'230227','富裕县','230200');
INSERT INTO hat_area VALUES (674,'230229','克山县','230200');
INSERT INTO hat_area VALUES (675,'230230','克东县','230200');
INSERT INTO hat_area VALUES (676,'230231','拜泉县','230200');
INSERT INTO hat_area VALUES (677,'230281','讷河市','230200');
INSERT INTO hat_area VALUES (678,'230301','市辖区','230300');
INSERT INTO hat_area VALUES (679,'230302','鸡冠区','230300');
INSERT INTO hat_area VALUES (680,'230303','恒山区','230300');
INSERT INTO hat_area VALUES (681,'230304','滴道区','230300');
INSERT INTO hat_area VALUES (682,'230305','梨树区','230300');
INSERT INTO hat_area VALUES (683,'230306','城子河区','230300');
INSERT INTO hat_area VALUES (684,'230307','麻山区','230300');
INSERT INTO hat_area VALUES (685,'230321','鸡东县','230300');
INSERT INTO hat_area VALUES (686,'230381','虎林市','230300');
INSERT INTO hat_area VALUES (687,'230382','密山市','230300');
INSERT INTO hat_area VALUES (688,'230401','市辖区','230400');
INSERT INTO hat_area VALUES (689,'230402','向阳区','230400');
INSERT INTO hat_area VALUES (690,'230403','工农区','230400');
INSERT INTO hat_area VALUES (691,'230404','南山区','230400');
INSERT INTO hat_area VALUES (692,'230405','兴安区','230400');
INSERT INTO hat_area VALUES (693,'230406','东山区','230400');
INSERT INTO hat_area VALUES (694,'230407','兴山区','230400');
INSERT INTO hat_area VALUES (695,'230421','萝北县','230400');
INSERT INTO hat_area VALUES (696,'230422','绥滨县','230400');
INSERT INTO hat_area VALUES (697,'230501','市辖区','230500');
INSERT INTO hat_area VALUES (698,'230502','尖山区','230500');
INSERT INTO hat_area VALUES (699,'230503','岭东区','230500');
INSERT INTO hat_area VALUES (700,'230505','四方台区','230500');
INSERT INTO hat_area VALUES (701,'230506','宝山区','230500');
INSERT INTO hat_area VALUES (702,'230521','集贤县','230500');
INSERT INTO hat_area VALUES (703,'230522','友谊县','230500');
INSERT INTO hat_area VALUES (704,'230523','宝清县','230500');
INSERT INTO hat_area VALUES (705,'230524','饶河县','230500');
INSERT INTO hat_area VALUES (706,'230601','市辖区','230600');
INSERT INTO hat_area VALUES (707,'230602','萨尔图区','230600');
INSERT INTO hat_area VALUES (708,'230603','龙凤区','230600');
INSERT INTO hat_area VALUES (709,'230604','让胡路区','230600');
INSERT INTO hat_area VALUES (710,'230605','红岗区','230600');
INSERT INTO hat_area VALUES (711,'230606','大同区','230600');
INSERT INTO hat_area VALUES (712,'230621','肇州县','230600');
INSERT INTO hat_area VALUES (713,'230622','肇源县','230600');
INSERT INTO hat_area VALUES (714,'230623','林甸县','230600');
INSERT INTO hat_area VALUES (715,'230624','杜尔伯特蒙古族自治县','230600'); INSERT INTO hat_area VALUES (716,'230701','市辖区','230700');
INSERT INTO hat_area VALUES (717,'230702','伊春区','230700');
INSERT INTO hat_area VALUES (718,'230703','南岔区','230700');
INSERT INTO hat_area VALUES (719,'230704','友好区','230700');
INSERT INTO hat_area VALUES (720,'230705','西林区','230700');
INSERT INTO hat_area VALUES (721,'230706','翠峦区','230700'); INSERT INTO hat_area VALUES (722,'230707','新青区','230700'); INSERT INTO hat_area VALUES (723,'230708','美溪区','230700'); INSERT INTO hat_area VALUES (724,'230709','金山屯区','230700'); INSERT INTO hat_area VALUES (725,'230710','五营区','230700'); INSERT INTO hat_area VALUES (726,'230711','乌马河区','230700'); INSERT INTO hat_area VALUES (727,'230712','汤旺河区','230700'); INSERT INTO hat_area VALUES (728,'230713','带岭区','230700'); INSERT INTO hat_area VALUES (729,'230714','乌伊岭区','230700'); INSERT INTO hat_area VALUES (730,'230715','红星区','230700'); INSERT INTO hat_area VALUES (731,'230716','上甘岭区','230700'); INSERT INTO hat_area VALUES (732,'230722','嘉荫县','230700'); INSERT INTO hat_area VALUES (733,'230781','铁力市','230700'); INSERT INTO hat_area VALUES (734,'230801','市辖区','230800'); INSERT INTO hat_area VALUES (735,'230802','永红区','230800'); INSERT INTO hat_area VALUES (736,'230803','向阳区','230800'); INSERT INTO hat_area VALUES (737,'230804','前进区','230800'); INSERT INTO hat_area VALUES (738,'230805','东风区','230800'); INSERT INTO hat_area VALUES (739,'230811','郊区','230800'); INSERT INTO hat_area VALUES (740,'230822','桦南县','230800'); INSERT INTO hat_area VALUES (741,'230826','桦川县','230800'); INSERT INTO hat_area VALUES (742,'230828','汤原县','230800'); INSERT INTO hat_area VALUES (743,'230833','抚远县','230800'); INSERT INTO hat_area VALUES (744,'230881','同江市','230800'); INSERT INTO hat_area VALUES (745,'230882','富锦市','230800'); INSERT INTO hat_area VALUES (746,'230901','市辖区','230900'); INSERT INTO hat_area VALUES (747,'230902','新兴区','230900'); INSERT INTO hat_area VALUES (748,'230903','桃山区','230900'); INSERT INTO hat_area VALUES (749,'230904','茄子河区','230900'); INSERT INTO hat_area VALUES (750,'230921','勃利县','230900'); INSERT INTO hat_area VALUES (751,'231001','市辖区','231000'); INSERT INTO hat_area VALUES (752,'231002','东安区','231000'); INSERT INTO hat_area VALUES (753,'231003','阳明区','231000'); INSERT INTO hat_area VALUES (754,'231004','爱民区','231000'); INSERT INTO hat_area VALUES (755,'231005','西安区','231000'); INSERT INTO hat_area VALUES (756,'231024','东宁县','231000'); INSERT INTO hat_area VALUES (757,'231025','林口县','231000'); INSERT INTO hat_area VALUES (758,'231081','绥芬河市','231000'); INSERT INTO hat_area VALUES (759,'231083','海林市','231000'); INSERT INTO hat_area VALUES (760,'231084','宁安市','231000'); INSERT INTO hat_area VALUES (761,'231085','穆棱市','231000'); INSERT INTO hat_area VALUES (762,'231101','市辖区','231100'); INSERT INTO hat_area VALUES (763,'231102','爱辉区','231100'); INSERT INTO hat_area VALUES (764,'231121','嫩江县','231100');
INSERT INTO hat_area VALUES (765,'231123','逊克县','231100'); INSERT INTO hat_area VALUES (766,'231124','孙吴县','231100'); INSERT INTO hat_area VALUES (767,'231181','北安市','231100'); INSERT INTO hat_area VALUES (768,'231182','五大连池市','231100'); INSERT INTO hat_area VALUES (769,'231201','市辖区','231200'); INSERT INTO hat_area VALUES (770,'231202','北林区','231200'); INSERT INTO hat_area VALUES (771,'231221','望奎县','231200'); INSERT INTO hat_area VALUES (772,'231222','兰西县','231200'); INSERT INTO hat_area VALUES (773,'231223','青冈县','231200'); INSERT INTO hat_area VALUES (774,'231224','庆安县','231200'); INSERT INTO hat_area VALUES (775,'231225','明水县','231200'); INSERT INTO hat_area VALUES (776,'231226','绥棱县','231200'); INSERT INTO hat_area VALUES (777,'231281','安达市','231200'); INSERT INTO hat_area VALUES (778,'231282','肇东市','231200'); INSERT INTO hat_area VALUES (779,'231283','海伦市','231200'); INSERT INTO hat_area VALUES (780,'232721','呼玛县','232700'); INSERT INTO hat_area VALUES (781,'232722','塔河县','232700'); INSERT INTO hat_area VALUES (782,'232723','漠河县','232700'); INSERT INTO hat_area VALUES (783,'310101','黄浦区','310100'); INSERT INTO hat_area VALUES (784,'310103','卢湾区','310100'); INSERT INTO hat_area VALUES (785,'310104','徐汇区','310100'); INSERT INTO hat_area VALUES (786,'310105','长宁区','310100'); INSERT INTO hat_area VALUES (787,'310106','静安区','310100'); INSERT INTO hat_area VALUES (788,'310107','普陀区','310100'); INSERT INTO hat_area VALUES (789,'310108','闸北区','310100'); INSERT INTO hat_area VALUES (790,'310109','虹口区','310100'); INSERT INTO hat_area VALUES (791,'310110','杨浦区','310100'); INSERT INTO hat_area VALUES (792,'310112','闵行区','310100'); INSERT INTO hat_area VALUES (793,'310113','宝山区','310100'); INSERT INTO hat_area VALUES (794,'310114','嘉定区','310100'); INSERT INTO hat_area VALUES (795,'310115','浦东新区','310100'); INSERT INTO hat_area VALUES (796,'310116','金山区','310100'); INSERT INTO hat_area VALUES (797,'310117','松江区','310100'); INSERT INTO hat_area VALUES (798,'310118','青浦区','310100'); INSERT INTO hat_area VALUES (799,'310119','南汇区','310100'); INSERT INTO hat_area VALUES (800,'310120','奉贤区','310100'); INSERT INTO hat_area VALUES (801,'310230','崇明县','310200'); INSERT INTO hat_area VALUES (802,'320101','市辖区','320100'); INSERT INTO hat_area VALUES (803,'320102','玄武区','320100'); INSERT INTO hat_area VALUES (804,'320103','白下区','320100'); INSERT INTO hat_area VALUES (805,'320104','秦淮区','320100'); INSERT INTO hat_area VALUES (806,'320105','建邺区','320100'); INSERT INTO hat_area VALUES (807,'320106','鼓楼区','320100'); INSERT INTO hat_area VALUES (808,'320107','下关区','320100');
INSERT INTO hat_area VALUES (809,'320111','浦口区','320100'); INSERT INTO hat_area VALUES (810,'320113','栖霞区','320100'); INSERT INTO hat_area VALUES (811,'320114','雨花台区','320100'); INSERT INTO hat_area VALUES (812,'320115','江宁区','320100'); INSERT INTO hat_area VALUES (813,'320116','六合区','320100'); INSERT INTO hat_area VALUES (814,'320124','溧水县','320100'); INSERT INTO hat_area VALUES (815,'320125','高淳县','320100'); INSERT INTO hat_area VALUES (816,'320201','市辖区','320200'); INSERT INTO hat_area VALUES (817,'320202','崇安区','320200'); INSERT INTO hat_area VALUES (818,'320203','南长区','320200'); INSERT INTO hat_area VALUES (819,'320204','北塘区','320200'); INSERT INTO hat_area VALUES (820,'320205','锡山区','320200'); INSERT INTO hat_area VALUES (821,'320206','惠山区','320200'); INSERT INTO hat_area VALUES (822,'320211','滨湖区','320200'); INSERT INTO hat_area VALUES (823,'320281','江阴市','320200'); INSERT INTO hat_area VALUES (824,'320282','宜兴市','320200'); INSERT INTO hat_area VALUES (825,'320301','市辖区','320300'); INSERT INTO hat_area VALUES (826,'320302','鼓楼区','320300'); INSERT INTO hat_area VALUES (827,'320303','云龙区','320300'); INSERT INTO hat_area VALUES (828,'320304','九里区','320300'); INSERT INTO hat_area VALUES (829,'320305','贾汪区','320300'); INSERT INTO hat_area VALUES (830,'320311','泉山区','320300'); INSERT INTO hat_area VALUES (831,'320321','丰县','320300'); INSERT INTO hat_area VALUES (832,'320322','沛县','320300'); INSERT INTO hat_area VALUES (833,'320323','铜山县','320300'); INSERT INTO hat_area VALUES (834,'320324','睢宁县','320300'); INSERT INTO hat_area VALUES (835,'320381','新沂市','320300'); INSERT INTO hat_area VALUES (836,'320382','邳州市','320300'); INSERT INTO hat_area VALUES (837,'320401','市辖区','320400'); INSERT INTO hat_area VALUES (838,'320402','天宁区','320400'); INSERT INTO hat_area VALUES (839,'320404','钟楼区','320400'); INSERT INTO hat_area VALUES (840,'320405','戚墅堰区','320400'); INSERT INTO hat_area VALUES (841,'320411','新北区','320400'); INSERT INTO hat_area VALUES (842,'320412','武进区','320400'); INSERT INTO hat_area VALUES (843,'320481','溧阳市','320400'); INSERT INTO hat_area VALUES (844,'320482','金坛市','320400'); INSERT INTO hat_area VALUES (845,'320501','市辖区','320500'); INSERT INTO hat_area VALUES (846,'320502','沧浪区','320500'); INSERT INTO hat_area VALUES (847,'320503','平江区','320500'); INSERT INTO hat_area VALUES (848,'320504','金阊区','320500'); INSERT INTO hat_area VALUES (849,'320505','虎丘区','320500'); INSERT INTO hat_area VALUES (850,'320506','吴中区','320500'); INSERT INTO hat_area VALUES (851,'320507','相城区','320500'); INSERT INTO hat_area VALUES (852,'320581','常熟市','320500');
全国省市县SQL数据库(大全)
全国省市县SQL数据库（大全） 创建表 reate table city( id int(11) primary key not null default 0 pid int(11) default null cityname varchar(255) default null type int(11) default null ); 插入数据 INSERT INTO `city` VALUES ('1' '0' '中国' '0'); INSERT INTO `city` VALUES ('2' '1' '北京' '1'); INSERT INTO `city` VALUES ('3' '1' '安徽' '1'); INSERT INTO `city` VALUES ('4' '1' '福建' '1'); INSERT INTO `city` VALUES ('5' '1' '甘肃' '1'); INSERT INTO `city` VALUES ('6' '1' '广东' '1'); INSERT INTO `city` VALUES ('7' '1' '广西' '1'); INSERT INTO `city` VALUES ('8' '1' '贵州' '1'); INSERT INTO `city` VALUES ('9' '1' '海南' '1'); INSERT INTO `city` VALUES ('10' '1' '河北' '1'); INSERT INTO `city` VALUES ('11' '1' '河南' '1'); INSERT INTO `city` VALUES ('12' '1' '黑龙江' '1'); INSERT INTO `city` VALUES ('13' '1' '湖北' '1'); INSERT INTO `city` VALUES ('14' '1' '湖南' '1'); INSERT INTO `city` VALUES ('15' '1' '吉林' '1'); INSERT INTO `city` VALUES ('16' '1' '江苏' '1'); INSERT INTO `city` VALUES ('17' '1' '江西' '1'); INSERT INTO `city` VALUES ('18' '1' '辽宁' '1'); INSERT INTO `city` VALUES ('19' '1' '内蒙古' '1'); INSERT INTO `city` VALUES ('20' '1' '宁夏' '1'); INSERT INTO `city` VALUES ('21' '1' '青海' '1'); INSERT INTO `city` VALUES ('22' '1' '山东' '1'); INSERT INTO `city` VALUES ('23' '1' '山西' '1'); INSERT INTO `city` VALUES ('24' '1' '陕西' '1'); INSERT INTO `city` VALUES ('25' '1' '上海' '1'); INSERT INTO `city` VALUES ('26' '1' '四川' '1'); INSERT INTO `city` VALUES ('27' '1' '天津' '1'); INSERT INTO `city` VALUES ('28' '1' '西藏' '1'); INSERT INTO `city` VALUES ('29' '1' '新疆' '1'); INSERT INTO `city` VALUES ('30' '1' '云南' '1'); INSERT INTO `city` VALUES ('31' '1' '浙江' '1'); INSERT INTO `city` VALUES ('32' '1' '重庆' '1');
数据库建表操作SQL代码大全
?首页 ?发现小组 ?发现小站 ?线上活动 joshua的日记 ?joshua的主页 ?广播 ?相册 ?喜欢 ?二手 ?活动 ?发豆邮 数据库建表操作SQL代码大全 2009-04-23 17:39:37 决定在这里建立自己的学习数据库的日记，以便随时学习，随时回顾。 从今天开始。 新建表： create table [表名] ( [自动编号字段] int IDENTITY (1,1) PRIMARY KEY , [字段1] nVarChar(50) default '默认值' null , [字段2] ntext null , [字段3] datetime, [字段4] money null , [字段5] int default 0, [字段6] Decimal (12,4) default 0, [字段7] image null , ) 删除表： Drop table [表名]
INSERT INTO [表名] (字段1,字段2) VALUES (100,'https://www.wendangku.net/doc/6019028378.html,') 删除数据： DELETE FROM [表名] WHERE [字段名]>100 更新数据： UPDATE [表名] SET [字段1] = 200,[字段2] = 'https://www.wendangku.net/doc/6019028378.html,' WHERE [字段三] = 'HAIWA' 新增字段： ALTER TABLE [表名] ADD [字段名] NVARCHAR (50) NULL 删除字段： ALTER TABLE [表名] DROP COLUMN [字段名] 修改字段： ALTER TABLE [表名] ALTER COLUMN [字段名] NVARCHAR (50) NULL 重命名表：(Access 重命名表，请参考文章：在Access数据库中重命名表) sp_rename '表名', '新表名', 'OBJECT' 新建约束： ALTER TABLE [表名] ADD CONSTRAINT 约束名CHECK ([约束字段] <= '2000-1-1') 删除约束： ALTER TABLE [表名] DROP CONSTRAINT 约束名 新建默认值 ALTER TABLE [表名] ADD CONSTRAINT 默认值名DEFAULT 'https://www.wendangku.net/doc/6019028378.html,' FOR [字段名] 删除默认值 ALTER TABLE [表名] DROP CONSTRAINT 默认值名 删除Sql Server 中的日志，减小数据库文件大小 dump transaction 数据库名with no_log backup log 数据库名with no_log dbcc shrinkdatabase(数据库名) exec sp_dboption '数据库名', 'autoshrink', 'true' \'添加字段通用函数 Sub AddColumn(TableName,ColumnName,ColumnType) Conn.Execute("Alter Table "&TableName&" Add "&ColumnName&" "&ColumnType&"") End Sub
三级等保SQL数据库指导书(三级)
控制点控制项核查内容核查方法推荐值结果判定备注 身份鉴别a)应对登录数据库系统的用 户进行身份标识和鉴别 检查数据字典user use mysql; select user from user; 右击服务器-属性-安全性-身份验证 显示所有能登录数据库 的用户信息 选：“sql server 和 windows” 全部不符合：0分 全部符合：5分 身份鉴别b)数据库系统管理用户身份 标识应具有不易被冒用的 特点，口令应有复杂度要求 并定期更换 询问管理员使用的口 令（如默认帐号root） 是否复杂度，并且是 否定期进行更换 询问 口令长度8位 定期更换口令 全部不符合：0分 全部符合：5分 口令复杂度3 定期更换2 身份鉴别c)应启用登录失败处理功 能，可采取结束会话、限制 非法登录次数和自动退出 等措施 查看my.ini文件中 max_connect_errors 参数的值 查看安装目录下my.ini配置文件的 max_connect_errors参数 max_connect_errors = 5 全部不符合：0分 全部符合：5分 登录失败次数2 自动退出1 口令锁定2 身份鉴别d)当对服务器进行远程管理 时，应采取必要措施，防止 鉴别信息在网络传输过程 中被窃听 询问管理员通过何种 方式管理数据库 询问 使用的管理工具应能对 网络传输的数据进行加 密 全部不符合：0分 全部符合：5分 配置sql server保 证传输加密 身份鉴别e)应为数据库系统的不同用 户分配不同的用户名，确保 用户名具有唯一性 询问数据库管理员是 否存在多个用户使用 同一帐号的情况 询问 不使用同一帐号进行管 理 全部不符合：0分 全部符合：5分 几个人使用数据 库，存在几个账户
中国省市区三级数据库表.sql
# MySQL-Front 5.1 (Build 2.7) /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; # Host: localhost Database: iptohat_area # ------------------------------------------------------ # Server version 5.0.26 # # Source for table hat_area # CREATE TABLE hat_area ( id int(11) NOT NULL auto_increment, areaID varchar(50) default NULL, area varchar(60) default NULL, father varchar(6) default NULL, primary key(id) ) ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8; # # Dumping data for table hat_area # INSERT INTO hat_area VALUES (1,'110101','东城区','110100'); INSERT INTO hat_area VALUES (2,'110102','西城区','110100'); INSERT INTO hat_area VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_area VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_area VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_area VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_area VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_area VALUES (10,'110111','房山区','110100'); INSERT INTO hat_area VALUES (11,'110112','通州区','110100'); INSERT INTO hat_area VALUES (12,'110113','顺义区','110100'); INSERT INTO hat_area VALUES (13,'110114','昌平区','110100'); INSERT INTO hat_area VALUES (14,'110115','大兴区','110100'); INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100'); INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');
全国计算机三级数据库考试真题
全国计算机三级数据库考试真题 一、选择题(每小题1分，共60分) (1)下列哪一个不是指令系统中包含的指令类型？^存储控制类指令 B)数据传送类指令 C)算术逻辑类指令 D)判定控制类指令 ⑵计算机存储容量大小为118，相当于多少GB? A)256GB B)512GB C)1024GB D)2048GB ⑶下列哪一个不属于广域网 A)X.5 B)FDDI C)ISDN D)ATM ⑷下列哪一个不属于应用层协议 A)用户数据报协议UDP 8)文件传瑜协议FTP
C)域名服务DNS D)电子邮件协议SMTP （5）下列哪一个不属于实施信息认证的方法？ A）身份识别 B）消息验证 C）密钥管理 D）数字签名 （6）密钥管理包括密钥的产生、存储、装入、分配、保护、丢失、销毁以及保密等内容，其中最关键和最困难的问题是A）解决密钥的丢失和销毁 B）解决密钥的分配和存储 C）解决密钥的产生和装入 D）解决密钥的保护和保密 （7）下列哪些是数据结构研究的内容？ I.数据的采集和清洗 II.数据的逻辑组织 III.数据的集成 IV.数据的传输 V.数据的检索
A）仅II 和III B）仅II和V C）仅I、II 和IV D）仅I、III 和V （8）下列哪一个术语与数据的存储结构无关？ A)顺序表 8)双链表 C)线性表 D)散列表 (9)下列关于串的叙述中，哪一条是正确的？ A)串是由至少I个字符组成的有限序列 B)串中字符的数日就是串的长度 C)串只能顺序存储 口)推入是串的基本运算之一 第(10)-(11)题基干以下描述：有一个初始为空的栈和下面的输入序列A,B,C,D,E,F;现经过如下操作:push, push, push, top, pop, top, pop, push, push, top, pop, pop, pop, push。 (10)下列哪一个是正确的从栈中删除元素的序列？ A)CBE B)EBD C)BEDCA D)CBEDA
sql数据库建表
1．写出创建如下三张表的SQL语句，要求在定义表的同时定义数据的完整性约束：（1）“图书表”结构如下： 书号：统一字符编码定长类型，长度为6，主键； 书名：统一字符编码可变长类型，长度为30，非空； 第一作者：普通编码定长字符类型，长度为10，非空； 出版日期：小日期时间型； 价格：定点小数，小数部分1位，整数部分3位。 （2）“书店表”结构如下： 书店编号：统一字符编码定长类型，长度为6，主键； 店名：统一字符编码可变长类型，长度为30，非空； 电话：普通编码定长字符类型，8位长，每一位的取值均是0～9的数字； 地址：普通编码可变长字符类型，40位长。 邮政编码：普通编码定长字符类型，6位长。 （3）“图书销售表”结构如下： 书号：统一字符编码定长类型，长度为6，非空； 书店编号：统一字符编码定长类型，长度为6，非空； 销售日期：小日期时间型，非空； 销售数量：小整型，大于等于1。 主键为（书号，书店编号，销售日期）； 其中“书号”为引用“图书表”的“书号”的外键； “书店编号”为引用“书店表”的“书店编号”的外键。 答： CREATE TABLE 图书表( 书号nchar(6) primary key, 书名nvarchar(30) not null, 第一作者char(10) not null, 出版日期smalldatetime, 价格numeric(4,1)) CREATE TABLE 书店表( 书店编号nchar(6) primary key, 店名nvarchar(30) not null, 电话char(8) check (电话like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'), 地址varchar(40), 邮政编码char(6)) CREATE TABLE 图书销售表( 书号nchar(6) not null, 书店编号nchar(6) not null, 销售日期smalldatetime not null, 销售数量smallint check(销售数量>=1), primary key(书号,书店编号,销售日期), foreign key(书号) references 图书表(书号), foreign key(书店编号) references 书店表(书店编号))
计算机三级数据库
计算机三级数据库 概述 计算机三级数据库是指在计算机技术考试中的一个级别分类，表示了数据库相关知识的熟练程度。在这个级别中，涵盖了数据库基础知识、数据库设计与规范、SQL语言应用、数据库管理等方面的内容。本文将介绍计算机三级数据库的相关知识和要点。 数据库基础知识 数据库是计算机存储、管理和检索数据的一种结构化方式。在数据库基础知识中，我们需要了解以下概念： 数据库的定义 数据库是指存储在计算机上的数据集合，它具有长期存储、可共享、可并发访问的特点。数据库可以分为关系型数据库、非关系型数据库等不同类型。
数据库的组成 数据库由数据、数据结构、数据管理系统（DBMS）三部分组成。数据是数据库中的实际信息，数据结构定义了数据存储的方式，而DBMS则是管理和操作数据的软件系统。 数据库的优点 数据库的使用有以下优点：数据共享性高，数据冗余度低，数据一致性好，数据安全性高等，这些特点使得数据库成为数据管理的重要工具。 数据库设计与规范 数据库设计是数据库开发的重要环节，良好的数据库设计 可以提高数据的存储效率和查询效率。在数据库设计与规范中，我们需要注意以下几点： 实体关系模型 实体关系模型（ERM）是描述数据库中实体（entity）和实体之间关系（relationship）的一种方法。它将现实世界的实 体和关系映射为数据库中的表和表之间的关系。
数据库范式是用来规范数据库设计的一组概念，它有不同 的级别，从第一范式到第五范式。范式的应用可以避免数据冗余和数据更新异常，提高数据库的稳定性和一致性。 数据库索引 数据库索引是一种用于加快数据检索速度的数据结构。合 理地创建和使用索引可以提高数据库的查询效率。索引的设计需要考虑到查询频率、数据的唯一性等因素。 SQL语言应用 SQL（Structured Query Language）是用于操作和管理关系型数据库的编程语言。在SQL语言应用中，我们需要掌握以 下几点： SQL基本语法 SQL包含了一系列的命令和语句，用于创建、修改和查询 数据库中的数据和结构。我们需要了解SQL的基本语法，包 括SELECT、UPDATE、INSERT和DELETE等命令的使用方式。
全国计算机等级考试三级数据库技术
全国计算机等级考试三级数据库技术 介绍 全国计算机等级考试（National Computer Rank Examination， 简称NCRE）是由中国国家教育部主管，中国计算机教育与应用研究中心（中国计算机协会下属机构）主办的一项职业资格认证考试，涵盖了计算机基础知识、计算机专业知识、计算机应用能力三个方面，包括初、中、高三个级别。其中，三级数据库技术考试主要测试考生的数据库基础知识、SQL语言基 础以及MySQL数据库应用等方面。 考试大纲 三级数据库技术考试大纲主要包括以下内容： 1. 数据库基础知识 数据库的基本概念、分类和特点；数据模型的基本概念和分类；关系数据库的基本概念、组成和特点；数据库管理系统的基本概念和组成；数据库设计的基本原则和方法。 2. SQL语言基础 SQL语言的基本概念、分类和特点；SQL命令的基本语法和 使用规则；SQL语句的组成和执行顺序；数据的查询、插入、修改和删除等基本操作；SQL函数的使用方法和分类；SQL 语言中的约束、索引和事务等。
3. MySQL数据库应用 MySQL数据库的安装和配置；MySQL数据库的管理和维护操作；MySQL数据库的备份和恢复；MySQL数据库的查询优化和索引优化；MySQL数据库的应用程序开发和部署；MySQL 数据库的安全和权限控制等。 考试方式 三级数据库技术考试采用笔试方式，分为两部分：选择题和操作题。选择题共计50道，每题1分，操作题共计5道，每题10分，总分为100分，考试时间为120分钟。 考试通过标准 考试通过的标准为：总分不少于60分，选择题的分数不低于25分，操作题的分数不低于35分。考试成绩有效期为两年。 考试报名 考生可以在每年的4月1日至5月31日和10月1日至11月30日到当地的NCRE考试中心报名参加考试。考试费用为300元。 考试证书 考试合格的考生可领取由中国计算机教育与应用研究中心颁发
数据库多表查询sql语句
数据库多表查询sql语句 数据库多表查询sql语句是访问多张表进行读取操作时常用的sql语句，它涉及到了对数据库中表之间的链接。本文将对数据库多表查询SQL语句功能和操作步骤进行介绍，以便更好地理解它在数据库系统中的重要性。 1. SQL多表查询的功能： SQL多表查询的主要功能是从多个表中获取数据。它可以在多个表中比较、汇总、复制和组合数据。通过建立表之间的关联可以访问多个表的数据。SQL多表查询可以使用内连接和外连接的方法，来查询不同表之间的关联数据。 2. SQL多表查询的操作步骤： （1）创建表：首先，在数据库中创建若干表，并为每个表定义合适的字段和数据类型； （2）链接表：然后，建立这些表之间的关联，并使用join关键字，给这些表之间的链接定义一个名称； （3）写sql语句：接着，使用select语句，在多个表之间查询需要的记录； （4）执行sql语句：最后，使用execute或run关键字，执行定义好的sql语句，从而获得查询结果。 SQL多表查询是数据库系统中一项重要的技术，在具体操作中还需要遵守一定的语法规则，以达到最佳的查询效果。一般来说，要使用多表查询，首先得在查询语句中明确指出要使用哪几张表，如何实
现表的链接，以及链接条件。 数据库多表查询是操作数据库时常用的技术，它包含了多个表之间的关联，可以有效地访问和复制数据库中的信息。此外，它还支持多表之间的联合查询，便于对多张表中的数据进行分析和统计。这对于分析复杂的信息来说尤其有用。 以上就是关于数据库多表查询sql语句的介绍，它应用范围广泛，能够有效地解决各种数据库问题，是数据库系统中不可或缺的技术。本文仅对SQL多表查询的功能和操作步骤做了简单介绍，希望能够给读者提供一些参考。
计算机三级数据库技术SQL基础知识点
计算机三级数据库技术SQL基础知识点 导语：SQL是一种特殊目的的编程语言，是一种数据库查询和程序设计语言，用于存取数据以及查询、更新和管理关系数据库系统;同时也是数据库脚本文件的扩展名。下面是计算机三级数据库技术SQL基础知识点，一起来学习下吧： 1、说明：创建数据库 CREATE __E database-name 2、说明：删除数据库 drop database dbname 3、说明：备份sql server __ 创建备份数据的device USE master EXEC sp_addumpdevice 'disk', 'testBack', 'c:mssql7backupMyNwind_1.dat' __ 开始备份 BACKUP __E pubs TO testBack 4、说明：创建新表 create table tabnamecol1 type1 [not null] [primary key],col2 type2 [not null],. 根据已有的表创建新表：
A：create table tab_new like tab_old 使用旧表创建新表 B：create table tab_new as select col1,col2。from tab_old definition only 5、说明：删除新表 tabname 6、说明：增加一个列 Alter table tabname add column col type 注：列增加后将不能删除。DB2中列加上后数据类型也不能改变，唯一能改变的是增加varchar类型的长度。 7、说明：添加主键：Alter table tabname add primary keycol 说明：删除主键：Alter table tabname drop primary keycol 8、说明：创建索引：create [unique] index idxname on tabnamecol。. 删除索引：drop index idxname 注：索引是不可更改的，想更改必须删除重新建。 9、说明：创建视图：create view viewname as select statement 删除视图：drop view viewname 10、说明：几个简单的基本的sql语句 选择：select * from table1 where 范围 插入：into table1field1,field2 valuesvalue1,value2 删除：from table1 where 范围
三级数据库知识点总结
三级数据库知识点总结 一、数据库的概念和分类 数据库是指长期存储在计算机内、有组织、可共享的大量数据的集合。根据数据的组织形式和存储方式，数据库可以分为层次数据库、网状数据库和关系数据库三个级别。 1. 层次数据库 层次数据库是以树形结构组织数据的数据库，数据之间的关系由层次结构来表示。其中，每个数据记录都有一个父节点和若干个子节点，形成了一个树形结构。层次数据库的优点是查询速度快，但缺点是数据结构复杂，不适合处理复杂的关系。 2. 网状数据库 网状数据库是以图形结构组织数据的数据库，数据之间的关系由网状结构来表示。其中，每个数据记录可以有多个父节点和多个子节点，形成了一个网状结构。网状数据库的优点是能够处理复杂的关系，但缺点是数据结构仍然较为复杂，不易维护和查询。 3. 关系数据库 关系数据库是以表格形式组织数据的数据库，数据之间的关系由表格的行和列来表示。其中，每个表格都有一个主键来唯一标识每条记录，而不同表格之间的关系通过外键来建立。关系数据库的优点是结构简单、易于维护和查询，目前应用最广泛。
二、关系型数据库的特点和常见操作 关系型数据库是指基于关系模型的数据库，具有以下特点： 1. 数据以表格形式存储，每个表格由行和列组成； 2. 每个表格有一个主键来唯一标识每条记录； 3. 不同表格之间通过外键建立关系； 4. 支持事务处理和数据一致性。 关系型数据库的常见操作包括： 1. 数据查询：使用SQL语言进行数据查询，包括简单的SELECT语句和复杂的JOIN操作； 2. 数据插入：使用INSERT语句将新数据插入到表格中； 3. 数据更新：使用UPDATE语句更新表格中的数据； 4. 数据删除：使用DELETE语句删除表格中的数据； 5. 数据排序：使用ORDER BY语句对查询结果进行排序； 6. 数据分组：使用GROUP BY语句对查询结果进行分组统计； 7. 数据联接：使用JOIN语句将不同表格之间的数据关联起来； 8. 数据备份和恢复：通过备份数据库文件来实现数据的安全存储和恢复。 三、关系型数据库的优缺点 关系型数据库具有以下优点：
sqlserver数据库表结构
sqlserver数据库表结构 SQL Server数据库表结构详解 一、用户表(user) 用户表是一个常见的数据库表结构，用于存储系统中的用户信息。该表通常包含以下字段： 1. 用户ID（user_id）：用于唯一标识每个用户的ID，通常为自增长的整数类型。 2. 用户名（username）：用户的登录名，通常为字符串类型，长度限制根据具体需求而定。 3. 密码（password）：用户的登录密码，通常为加密后的字符串类型。 4. 姓名（name）：用户的真实姓名，通常为字符串类型。 5. 性别（gender）：用户的性别，通常为枚举类型，如男、女等。 6. 手机号（phone）：用户的手机号码，通常为字符串类型，长度限制根据具体需求而定。 7. 邮箱（email）：用户的电子邮箱地址，通常为字符串类型，长度限制根据具体需求而定。 二、订单表(order) 订单表用于存储用户的订单信息，包含以下字段： 1. 订单ID（order_id）：用于唯一标识每个订单的ID，通常为自增长的整数类型。
2. 用户ID（user_id）：关联用户表的用户ID，表示该订单属于哪个用户。 3. 订单编号（order_number）：订单的编号，通常为字符串类型，长度限制根据具体需求而定。 4. 下单时间（create_time）：订单的创建时间，通常为日期时间类型。 5. 订单金额（amount）：订单的总金额，通常为浮点数类型，表示订单应付的金额。 6. 支付状态（payment_status）：订单的支付状态，通常为枚举类型，如未支付、已支付等。 三、商品表(product) 商品表用于存储系统中的商品信息，包含以下字段： 1. 商品ID（product_id）：用于唯一标识每个商品的ID，通常为自增长的整数类型。 2. 商品名称（product_name）：商品的名称，通常为字符串类型，长度限制根据具体需求而定。 3. 商品价格（price）：商品的价格，通常为浮点数类型，表示商品的单价。 4. 商品库存（stock）：商品的库存数量，通常为整数类型，表示商品的可售数量。 四、评论表(comment)
sql查询表结构导出数据字典表格语句
数据字典是数据库管理中非常重要的一部分，它记录了数据库中表的 结构以及表中字段的含义和属性。尤其是在开发和维护数据库系统时，数据字典可以帮助开发人员了解数据库结构，方便进行数据查询和维护。在本篇文章中，我们将介绍如何使用SQL查询数据库表结构并导出数据字典表格语句，帮助读者更好地管理数据库。 一、SQL查询表结构 1. 使用DESCRIBE命令查询表结构 在SQL中，可以使用DESCRIBE或DESC命令来查询数据库表的结构，该命令会返回表中的字段名、字段类型、字段长度以及是否可以为NULL等信息。 示例命令： DESCRIBE table_name; 2. 使用SHOW CREATE TABLE命令查询表结构 另外，还可以使用SHOW CREATE TABLE命令来查询表的创建语句，该命令会返回创建该表的SQL语句，包括表名、字段名、字段类型、主键、外键等信息。 示例命令： SHOW CREATE TABLE table_name;
二、导出数据字典表格语句 1. 导出查询结果到文件 在SQL中，可以使用SELECT ... INTO OUTFILE命令将查询结果导出到文件中，这样就可以将数据库表结构导出为数据字典表格语句，方便进行管理和查阅。 示例命令： SELECT column_name, data_type, character_maximum_length, is_nullable INTO OUTFILE '/path/to/dictionary_table.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM information_schema.columns WHERE table_schema = 'database_name' AND table_name = 'table_name'; 2. 将查询结果作为表插入到其他表 另外，还可以使用CREATE TABLE ... AS SELECT命令将查询结果作为一个新表插入到数据库中，这样就可以将数据库表结构导出为数据字典表格语句，方便进行管理和查阅。 示例命令： CREATE TABLE dictionary_table AS
全国省市县三级联动(数据完整版)
全国省市县三级联动（数据完整版） 网页前台代码： <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Defaul t" EnableEventValidation="false"%> <%@ Register assembly="AjaxControlToolkit"namespace="AjaxControlToolkit" tagprefix="cc1" %>