中国省市数据库表MYSQL版.docx

1、中国省市数据库表MYSQL版中国省市数据库表-MYSQL版 2010-05-15 14:22DROP TABLE IF EXISTS province; CREATE TABLE province (id int(11) NOT NULL AUTO_INCREMENT,name varchar(50) DEFAULT NULL,PRIMARY KEY (id) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;- - Records of province- -INSERT INTO province VALUES (1, 北京市);INS

2、ERT INTO province VALUES (2, 天津市);INSERT INTO province VALUES (3, 上海市);INSERT INTO province VALUES (4, 重庆市);INSERT INTO province VALUES (5, 河北省);INSERT INTO province VALUES (6, 山西省);INSERT INTO province VALUES (7, 台湾省);INSERT INTO province VALUES (8, 辽宁省);INSERT INTO province VALUES (9, 吉林省);INSERT

3、INTO province VALUES (10, 黑龙江省);INSERT INTO province VALUES (11, 江苏省);INSERT INTO province VALUES (12, 浙江省);INSERT INTO province VALUES (13, 安徽省);INSERT INTO province VALUES (14, 福建省);INSERT INTO province VALUES (15, 江西省);INSERT INTO province VALUES (16, 山东省);INSERT INTO province VALUES (17, 河南省);IN

4、SERT INTO province VALUES (18, 湖北省);INSERT INTO province VALUES (19, 湖南省);INSERT INTO province VALUES (20, 广东省);INSERT INTO province VALUES (21, 甘肃省);INSERT INTO province VALUES (22, 四川省);INSERT INTO province VALUES (23, 贵州省);INSERT INTO province VALUES (24, 海南省);INSERT INTO province VALUES (25, 云南省

5、);INSERT INTO province VALUES (26, 青海省);INSERT INTO province VALUES (27, 陕西省);INSERT INTO province VALUES (28, 广西壮族自治区);INSERT INTO province VALUES (29, 西藏自治区);INSERT INTO province VALUES (30, 宁夏回族自治区);INSERT INTO province VALUES (31, 新疆维吾尔自治区);INSERT INTO province VALUES (32, 内蒙古自治区);INSERT INTO pr

6、ovince VALUES (33, 澳门特别行政区);INSERT INTO province VALUES (34, 香港特别行政区);- - Table structure for city- -DROP TABLE IF EXISTS city;CREATE TABLE city (id int(11) NOT NULL AUTO_INCREMENT,city_index int(11) NOT NULL,province_id int(11) NOT NULL,name varchar(100) NOT NULL DEFAULT ,PRIMARY KEY (id) ENGINE=In

7、noDB AUTO_INCREMENT=392 DEFAULT CHARSET=gbk;- - Records of city- -INSERT INTO city VALUES (1, 1, 1, 北京市);INSERT INTO city VALUES (2, 1, 2, 天津市);INSERT INTO city VALUES (3, 1, 3, 上海市);INSERT INTO city VALUES (4, 1, 4, 重庆市);INSERT INTO city VALUES (5, 1, 5, 石家庄市);INSERT INTO city VALUES (6, 2, 5, 唐山市)

8、;INSERT INTO city VALUES (7, 3, 5, 秦皇岛市);INSERT INTO city VALUES (8, 4, 5, 邯郸市);INSERT INTO city VALUES (9, 5, 5, 邢台市);INSERT INTO city VALUES (10, 6, 5, 保定市);INSERT INTO city VALUES (11, 7, 5, 张家口市);INSERT INTO city VALUES (12, 8, 5, 承德市);INSERT INTO city VALUES (13, 9, 5, 沧州市);INSERT INTO city VAL

9、UES (14, 10, 5, 廊坊市);INSERT INTO city VALUES (15, 11, 5, 衡水市);INSERT INTO city VALUES (16, 1, 6, 太原市);INSERT INTO city VALUES (17, 2, 6, 大同市);INSERT INTO city VALUES (18, 3, 6, 阳泉市);INSERT INTO city VALUES (19, 4, 6, 长治市);INSERT INTO city VALUES (20, 5, 6, 晋城市);INSERT INTO city VALUES (21, 6, 6, 朔州市

10、);INSERT INTO city VALUES (22, 7, 6, 晋中市);INSERT INTO city VALUES (23, 8, 6, 运城市);INSERT INTO city VALUES (24, 9, 6, 忻州市);INSERT INTO city VALUES (25, 10, 6, 临汾市);INSERT INTO city VALUES (26, 11, 6, 吕梁市);INSERT INTO city VALUES (27, 1, 7, 台北市);INSERT INTO city VALUES (28, 2, 7, 高雄市);INSERT INTO city

11、 VALUES (29, 3, 7, 基隆市);INSERT INTO city VALUES (30, 4, 7, 台中市);INSERT INTO city VALUES (31, 5, 7, 台南市);INSERT INTO city VALUES (32, 6, 7, 新竹市);INSERT INTO city VALUES (33, 7, 7, 嘉义市);INSERT INTO city VALUES (34, 8, 7, 台北县);INSERT INTO city VALUES (35, 9, 7, 宜兰县);INSERT INTO city VALUES (36, 10, 7,

12、桃园县);INSERT INTO city VALUES (37, 11, 7, 新竹县);INSERT INTO city VALUES (38, 12, 7, 苗栗县);INSERT INTO city VALUES (39, 13, 7, 台中县);INSERT INTO city VALUES (40, 14, 7, 彰化县);INSERT INTO city VALUES (41, 15, 7, 南投县);INSERT INTO city VALUES (42, 16, 7, 云林县);INSERT INTO city VALUES (43, 17, 7, 嘉义县);INSERT I

13、NTO city VALUES (44, 18, 7, 台南县);INSERT INTO city VALUES (45, 19, 7, 高雄县);INSERT INTO city VALUES (46, 20, 7, 屏东县);INSERT INTO city VALUES (47, 21, 7, 澎湖县);INSERT INTO city VALUES (48, 22, 7, 台东县);INSERT INTO city VALUES (49, 23, 7, 花莲县);INSERT INTO city VALUES (50, 1, 8, 沈阳市);INSERT INTO city VALUE

14、S (51, 2, 8, 大连市);INSERT INTO city VALUES (52, 3, 8, 鞍山市);INSERT INTO city VALUES (53, 4, 8, 抚顺市);INSERT INTO city VALUES (54, 5, 8, 本溪市);INSERT INTO city VALUES (55, 6, 8, 丹东市);INSERT INTO city VALUES (56, 7, 8, 锦州市);INSERT INTO city VALUES (57, 8, 8, 营口市);INSERT INTO city VALUES (58, 9, 8, 阜新市);IN

15、SERT INTO city VALUES (59, 10, 8, 辽阳市);INSERT INTO city VALUES (60, 11, 8, 盘锦市);INSERT INTO city VALUES (61, 12, 8, 铁岭市);INSERT INTO city VALUES (62, 13, 8, 朝阳市);INSERT INTO city VALUES (63, 14, 8, 葫芦岛市);INSERT INTO city VALUES (64, 1, 9, 长春市);INSERT INTO city VALUES (65, 2, 9, 吉林市);INSERT INTO city

16、 VALUES (66, 3, 9, 四平市);INSERT INTO city VALUES (67, 4, 9, 辽源市);INSERT INTO city VALUES (68, 5, 9, 通化市);INSERT INTO city VALUES (69, 6, 9, 白山市);INSERT INTO city VALUES (70, 7, 9, 松原市);INSERT INTO city VALUES (71, 8, 9, 白城市);INSERT INTO city VALUES (72, 9, 9, 延边朝鲜族自治州);INSERT INTO city VALUES (73, 1,

17、 10, 哈尔滨市);INSERT INTO city VALUES (74, 2, 10, 齐齐哈尔市);INSERT INTO city VALUES (75, 3, 10, 鹤岗市);INSERT INTO city VALUES (76, 4, 10, 双鸭山市);INSERT INTO city VALUES (77, 5, 10, 鸡西市);INSERT INTO city VALUES (78, 6, 10, 大庆市);INSERT INTO city VALUES (79, 7, 10, 伊春市);INSERT INTO city VALUES (80, 8, 10, 牡丹江市

18、);INSERT INTO city VALUES (81, 9, 10, 佳木斯市);INSERT INTO city VALUES (82, 10, 10, 七台河市);INSERT INTO city VALUES (83, 11, 10, 黑河市);INSERT INTO city VALUES (84, 12, 10, 绥化市);INSERT INTO city VALUES (85, 13, 10, 大兴安岭地区);INSERT INTO city VALUES (86, 1, 11, 南京市);INSERT INTO city VALUES (87, 2, 11, 无锡市);IN

19、SERT INTO city VALUES (88, 3, 11, 徐州市);INSERT INTO city VALUES (89, 4, 11, 常州市);INSERT INTO city VALUES (90, 5, 11, 苏州市);INSERT INTO city VALUES (91, 6, 11, 南通市);INSERT INTO city VALUES (92, 7, 11, 连云港市);INSERT INTO city VALUES (93, 8, 11, 淮安市);INSERT INTO city VALUES (94, 9, 11, 盐城市);INSERT INTO ci

20、ty VALUES (95, 10, 11, 扬州市);INSERT INTO city VALUES (96, 11, 11, 镇江市);INSERT INTO city VALUES (97, 12, 11, 泰州市);INSERT INTO city VALUES (98, 13, 11, 宿迁市);INSERT INTO city VALUES (99, 1, 12, 杭州市);INSERT INTO city VALUES (100, 2, 12, 宁波市);INSERT INTO city VALUES (101, 3, 12, 温州市);INSERT INTO city VALU

21、ES (102, 4, 12, 嘉兴市);INSERT INTO city VALUES (103, 5, 12, 湖州市);INSERT INTO city VALUES (104, 6, 12, 绍兴市);INSERT INTO city VALUES (105, 7, 12, 金华市);INSERT INTO city VALUES (106, 8, 12, 衢州市);INSERT INTO city VALUES (107, 9, 12, 舟山市);INSERT INTO city VALUES (108, 10, 12, 台州市);INSERT INTO city VALUES (1

22、09, 11, 12, 丽水市);INSERT INTO city VALUES (110, 1, 13, 合肥市);INSERT INTO city VALUES (111, 2, 13, 芜湖市);INSERT INTO city VALUES (112, 3, 13, 蚌埠市);INSERT INTO city VALUES (113, 4, 13, 淮南市);INSERT INTO city VALUES (114, 5, 13, 马鞍山市);INSERT INTO city VALUES (115, 6, 13, 淮北市);INSERT INTO city VALUES (116,

23、7, 13, 铜陵市);INSERT INTO city VALUES (117, 8, 13, 安庆市);INSERT INTO city VALUES (118, 9, 13, 黄山市);INSERT INTO city VALUES (119, 10, 13, 滁州市);INSERT INTO city VALUES (120, 11, 13, 阜阳市);INSERT INTO city VALUES (121, 12, 13, 宿州市);INSERT INTO city VALUES (122, 13, 13, 巢湖市);INSERT INTO city VALUES (123, 14

24、, 13, 六安市);INSERT INTO city VALUES (124, 15, 13, 亳州市);INSERT INTO city VALUES (125, 16, 13, 池州市);INSERT INTO city VALUES (126, 17, 13, 宣城市);INSERT INTO city VALUES (127, 1, 14, 福州市);INSERT INTO city VALUES (128, 2, 14, 厦门市);INSERT INTO city VALUES (129, 3, 14, 莆田市);INSERT INTO city VALUES (130, 4, 1

25、4, 三明市);INSERT INTO city VALUES (131, 5, 14, 泉州市);INSERT INTO city VALUES (132, 6, 14, 漳州市);INSERT INTO city VALUES (133, 7, 14, 南平市);INSERT INTO city VALUES (134, 8, 14, 龙岩市);INSERT INTO city VALUES (135, 9, 14, 宁德市);INSERT INTO city VALUES (136, 1, 15, 南昌市);INSERT INTO city VALUES (137, 2, 15, 景德镇市);INSERT INTO city VALUES (138, 3, 15, 萍乡市);INSERT INTO city VALUES (139, 4, 15, 九江市);INSERT INTO city VALUES (140, 5, 15, 新余市);INSERT INTO city VALUES (141, 6, 15, 鹰潭市);INSERT INTO city VALUES (142, 7, 15, 赣州市);INSERT INTO city VALUES (143, 8, 15, 吉安市);I