中国34个省市自治区数据库

INSERT INTO city VALUES(20,'屏东县',7);
INSERT INTO city VALUES(21,'澎湖县',7);
INSERT INTO city VALUES(22,'台东县',7);
INSERT INTO city VALUES(23,'花莲县',7);
);
INSERT INTO city VALUES(1,'北京市',1);
INSERT INTO city VALUES(1,'天津市',2);
INSERT INTO city VALUES(1,'上海市',3);
INSERT INTO city VALUES(1,'重庆市',4);
INSERT INTO city VALUES(1,'石家庄市',5);
INSERT INTO city VALUES(6,'朔州市',6);
INSERT INTO city VALUES(7,'晋中市',6);
INSERT INTO city VALUES(8,'运城市',6);
INSERT INTO city VALUES(9,'忻州市',6);
INSERT INTO city VALUES(10,'临汾市',6);
INSERT INTO city VALUES(7,'张家口市',5);
INSERT INTO city VALUES(8,'承德市',5);
INSERT INTO city VALUES(9,'沧州市',5);
INSERT INTO city VALUES(10,'廊坊市',5);
INSERT INTO city VALUES(11,'衡水市',5);
INSERT INTO city VALUES(1,'长春市',9);
INSERT INTO city VALUES(2,'吉林市',9);
INSERT INTO city VALUES(3,'四平市',9);
INSERT INTO city VALUES(4,'辽源市',9);
INSERT INTO city VALUES(5,'通化市',9);
INSERT INTO province VALUES(19,'湖南省');
INSERT INTO province VALUES(20,'广东省');
INSERT INTO province VALUES(21,'甘肃省');
INSERT INTO province VALUES(22,'四川省');
INSERT INTO province VALUES(31,'新疆维吾尔自治区');
INSERT INTO province VALUES(32,'内蒙古自治区');
INSERT INTO province VALUES(33,'澳门特别行政区');
INSERT INTO province VALUES(34,'香港特别行政区');
INSERT INTO city VALUES(11,'盘锦市',8);
INSERT INTO city VALUES(12,'铁岭市',8);
INSERT INTO city VALUES(13,'朝阳市',8);
INSERT INTO city VALUES(14,'葫芦岛市',8);
INSERT INTO province VALUES(7,'台湾省');
INSERT INTO province VALUES(8,'辽宁省');
INSERT INTO province VALUES(9,'吉林省');
INSERT INTO province VALUES(10,'黑龙江省');
INSERT INTO city VALUES(11,'吕梁市',6);
INSERT INTO city VALUES(1,'台北市',7);
INSERT INTO city VALUES(2,'高雄市',7);
INSERT INTO city VALUES(3,'基隆市',7);
INSERT INTO city VALUES(4,'台中市',7);
INSERT INTO city VALUES(1,'太原市',6);
INSERT INTO city VALUES(2,'大同市',6);
INSERT INTO city VALUES(3,'阳泉市',6);
INSERT INTO city VALUES(4,'长治市',6);
INSERT INTO city VALUES(5,'晋城市',6);
INSERT INTO province VALUES(23,'贵州省');
INSERT INTO province VALUES(24,'海南省');
INSERT INTO province VALUES(25,'云南省');
INSERT INTO province VALUES(26,'青海省');
INSERT INTO province VALUES(11,'江苏省');
INSERT INTO province VALUES(12,'浙江省');
INSERT INTO province VALUES(13,'安徽省');
INSERT INTO province VALUES(14,'福建省');
CREATE TABLE city
(
cityID INT NOT NULL,
cityName VARCHAR(50); PRIMARY KEY,
proID INT NOT NULL,
CONSTRAINT FK_city FOREIGN KEY (proID) REFERENCES province (proID)
INSERT INTO province VALUES(15,'江西省');
INSERT INTO province VALUES(16,'山东省');
INSERT INTO province VALUES(17,'河南省');
INSERT INTO province VALUES(18,'湖北省');
INSERT INTO city VALUES(13,'大兴安岭地区',10);
INSERT INTO city VALUES(1,'南京市',11);
INSERT INTO city VALUES(2,'无锡市',11);
INSERT INTO city VALUES(3,'徐州市',11);
INSERT INTO city VALUES(1,'沈阳市',8);
INSERT INTO city VALUES(2,'大连市',8);
INSERT INTO city VALUES(3,'鞍山市',8);
INSERT INTO city VALUES(4,'抚顺市',8);
INSERT INTO city VALUES(5,'本溪市',8);
INSERT INTO city VALUES(6,'白山市',9);
INSERT INTO city VALUES(7,'松原市',9);
INSERT INTO city VALUES(8,'白城市',9);
INSERT INTO city VALUES(9,'延边朝鲜族自治州',9);
INSERT INTO province VALUES(3,'上海市');
INSERT INTO province VALUES(4,'重庆市');
INSERT INTO province VALUES(5,'河北省');
INSERT INTO province VALUES(6,'山西省');
INSERT INTO city VALUES(10,'桃园县',7);
INSERT INTO city VALUES(11,'新竹县',7);
INSERT INTO city VALUES(12,'苗栗县',7);
INSERT INTO city VALUES(13,'台中县',7);
INSERT INTO city VALUES(14,'彰化县',7);
INSERT INTO city VALUES(6,'丹东市',8);