SQLServer2005 高校教程 （SQL语句基础)

准备数据表

-- 创建表结构

create table borrow (
    cno char(5),bno char(5),bdate varchar(20) not null,primary key(cno,bno,bdate),foreign key(cno) references reader(cno),foreign key(bno) references book(bno) 
)
-- 创建索引
create index IX_BOOK_BNAME on book(bname desc)
-- 创建唯一性索引

create unique index IX_BORROW_ALL on borrow (rno,bno desc,bdate,desc)

查询每个图书的借阅情况

--每种图书的借阅情况
select book.*,rno,bdate
from book left outer join borrow on book.bno = borrow.bon

查询借阅中每个条信息的中，除去读者信息年龄大于 1997-7-01

select rno,rname,rdepartment
from reader
where rno not in(
        select rno 
        from borrow
        where bdate >= '1997-7-01'
)

查询借阅信息， 按照借阅读者信息分组， 查出每个借阅信息大于2的

select rdepartment,rno
from reader
where rno in (
    select rno
    from borrow
    group by rno
    having count(*) >= 2
)

select rtitle,count(*)  from reader group by rtitle

附录

全国省份城市关联数据表

use City;
DROP 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;

-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('1','北京市');
INSERT 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 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','河南省');
INSERT 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','云南省');
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 `province` 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=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('1','1','北京市');
INSERT INTO `city` VALUES ('2','2','天津市');
INSERT INTO `city` VALUES ('3','3','上海市');
INSERT INTO `city` VALUES ('4','4','重庆市');
INSERT INTO `city` VALUES ('5','5','石家庄市');
INSERT INTO `city` VALUES ('6','唐山市');
INSERT INTO `city` VALUES ('7','秦皇岛市');
INSERT INTO `city` VALUES ('8','邯郸市');
INSERT INTO `city` VALUES ('9','邢台市');
INSERT INTO `city` VALUES ('10','6','保定市');
INSERT INTO `city` VALUES ('11','7','张家口市');
INSERT INTO `city` VALUES ('12','8','承德市');
INSERT INTO `city` VALUES ('13','9','沧州市');
INSERT INTO `city` VALUES ('14','10','廊坊市');
INSERT INTO `city` VALUES ('15','11','衡水市');
INSERT INTO `city` VALUES ('16','太原市');
INSERT INTO `city` VALUES ('17','大同市');
INSERT INTO `city` VALUES ('18','阳泉市');
INSERT INTO `city` VALUES ('19','长治市');
INSERT INTO `city` VALUES ('20','晋城市');
INSERT INTO `city` VALUES ('21','朔州市');
INSERT INTO `city` VALUES ('22','晋中市');
INSERT INTO `city` VALUES ('23','运城市');
INSERT INTO `city` VALUES ('24','忻州市');
INSERT INTO `city` VALUES ('25','临汾市');
INSERT INTO `city` VALUES ('26','吕梁市');
INSERT INTO `city` VALUES ('27','台北市');
INSERT INTO `city` VALUES ('28','高雄市');
INSERT INTO `city` VALUES ('29','基隆市');
INSERT INTO `city` VALUES ('30','台中市');
INSERT INTO `city` VALUES ('31','台南市');
INSERT INTO `city` VALUES ('32','新竹市');
INSERT INTO `city` VALUES ('33','嘉义市');
INSERT INTO `city` VALUES ('34','台北县');
INSERT INTO `city` VALUES ('35','宜兰县');
INSERT INTO `city` VALUES ('36','桃园县');
INSERT INTO `city` VALUES ('37','新竹县');
INSERT INTO `city` VALUES ('38','12','苗栗县');
INSERT INTO `city` VALUES ('39','13','台中县');
INSERT INTO `city` VALUES ('40','14','彰化县');
INSERT INTO `city` VALUES ('41','15','南投县');
INSERT INTO `city` VALUES ('42','16','云林县');
INSERT INTO `city` VALUES ('43','17','嘉义县');
INSERT INTO `city` VALUES ('44','18','台南县');
INSERT INTO `city` VALUES ('45','19','高雄县');
INSERT INTO `city` VALUES ('46','20','屏东县');
INSERT INTO `city` VALUES ('47','21','澎湖县');
INSERT INTO `city` VALUES ('48','22','台东县');
INSERT INTO `city` VALUES ('49','23','花莲县');
INSERT INTO `city` VALUES ('50','沈阳市');
INSERT INTO `city` VALUES ('51','大连市');
INSERT INTO `city` VALUES ('52','鞍山市');
INSERT INTO `city` VALUES ('53','抚顺市');
INSERT INTO `city` VALUES ('54','本溪市');
INSERT INTO `city` VALUES ('55','丹东市');
INSERT INTO `city` VALUES ('56','锦州市');
INSERT INTO `city` VALUES ('57','营口市');
INSERT INTO `city` VALUES ('58','阜新市');
INSERT INTO `city` VALUES ('59','辽阳市');
INSERT INTO `city` VALUES ('60','盘锦市');
INSERT INTO `city` VALUES ('61','铁岭市');
INSERT INTO `city` VALUES ('62','朝阳市');
INSERT INTO `city` VALUES ('63','葫芦岛市');
INSERT INTO `city` VALUES ('64','长春市');
INSERT INTO `city` VALUES ('65','吉林市');
INSERT INTO `city` VALUES ('66','四平市');
INSERT INTO `city` VALUES ('67','辽源市');
INSERT INTO `city` VALUES ('68','通化市');
INSERT INTO `city` VALUES ('69','白山市');
INSERT INTO `city` VALUES ('70','松原市');
INSERT INTO `city` VALUES ('71','白城市');
INSERT INTO `city` VALUES ('72','延边朝鲜族自治州');
INSERT INTO `city` VALUES ('73','哈尔滨市');
INSERT INTO `city` VALUES ('74','齐齐哈尔市');
INSERT INTO `city` VALUES ('75','鹤岗市');
INSERT INTO `city` VALUES ('76','双鸭山市');
INSERT INTO `city` VALUES ('77','鸡西市');
INSERT INTO `city` VALUES ('78','大庆市');
INSERT INTO `city` VALUES ('79','伊春市');
INSERT INTO `city` VALUES ('80','牡丹江市');
INSERT INTO `city` VALUES ('81','佳木斯市');
INSERT INTO `city` VALUES ('82','七台河市');
INSERT INTO `city` VALUES ('83','黑河市');
INSERT INTO `city` VALUES ('84','绥化市');
INSERT INTO `city` VALUES ('85','大兴安岭地区');
INSERT INTO `city` VALUES ('86','南京市');
INSERT INTO `city` VALUES ('87','无锡市');
INSERT INTO `city` VALUES ('88','徐州市');
INSERT INTO `city` VALUES ('89','常州市');
INSERT INTO `city` VALUES ('90','苏州市');
INSERT INTO `city` VALUES ('91','南通市');
INSERT INTO `city` VALUES ('92','连云港市');
INSERT INTO `city` VALUES ('93','淮安市');
INSERT INTO `city` VALUES ('94','盐城市');
INSERT INTO `city` VALUES ('95','扬州市');
INSERT INTO `city` VALUES ('96','镇江市');
INSERT INTO `city` VALUES ('97','泰州市');
INSERT INTO `city` VALUES ('98','宿迁市');
INSERT INTO `city` VALUES ('99','杭州市');
INSERT INTO `city` VALUES ('100','宁波市');
INSERT INTO `city` VALUES ('101','温州市');
INSERT INTO `city` VALUES ('102','嘉兴市');
INSERT INTO `city` VALUES ('103','湖州市');
INSERT INTO `city` VALUES ('104','绍兴市');
INSERT INTO `city` VALUES ('105','金华市');
INSERT INTO `city` VALUES ('106','衢州市');
INSERT INTO `city` VALUES ('107','舟山市');
INSERT INTO `city` VALUES ('108','台州市');
INSERT INTO `city` VALUES ('109','丽水市');
INSERT INTO `city` VALUES ('110','合肥市');
INSERT INTO `city` VALUES ('111','芜湖市');
INSERT INTO `city` VALUES ('112','蚌埠市');
INSERT INTO `city` VALUES ('113','淮南市');
INSERT INTO `city` VALUES ('114','马鞍山市');
INSERT INTO `city` VALUES ('115','淮北市');
INSERT INTO `city` VALUES ('116','铜陵市');
INSERT INTO `city` VALUES ('117','安庆市');
INSERT INTO `city` VALUES ('118','黄山市');
INSERT INTO `city` VALUES ('119','滁州市');
INSERT INTO `city` VALUES ('120','阜阳市');
INSERT INTO `city` VALUES ('121','宿州市');
INSERT INTO `city` VALUES ('122','巢湖市');
INSERT INTO `city` VALUES ('123','六安市');
INSERT INTO `city` VALUES ('124','亳州市');
INSERT INTO `city` VALUES ('125','池州市');
INSERT INTO `city` VALUES ('126','宣城市');
INSERT INTO `city` VALUES ('127','福州市');
INSERT INTO `city` VALUES ('128','厦门市');
INSERT INTO `city` VALUES ('129','莆田市');
INSERT INTO `city` VALUES ('130','三明市');
INSERT INTO `city` VALUES ('131','泉州市');
INSERT INTO `city` VALUES ('132','漳州市');
INSERT INTO `city` VALUES ('133','南平市');
INSERT INTO `city` VALUES ('134','龙岩市');
INSERT INTO `city` VALUES ('135','宁德市');
INSERT INTO `city` VALUES ('136','南昌市');
INSERT INTO `city` VALUES ('137','景德镇市');
INSERT INTO `city` VALUES ('138','萍乡市');
INSERT INTO `city` VALUES ('139','九江市');
INSERT INTO `city` VALUES ('140','新余市');
INSERT INTO `city` VALUES ('141','鹰潭市');
INSERT INTO `city` VALUES ('142','赣州市');
INSERT INTO `city` VALUES ('143','吉安市');
INSERT INTO `city` VALUES ('144','宜春市');
INSERT INTO `city` VALUES ('145','抚州市');
INSERT INTO `city` VALUES ('146','上饶市');
INSERT INTO `city` VALUES ('147','济南市');
INSERT INTO `city` VALUES ('148','青岛市');
INSERT INTO `city` VALUES ('149','淄博市');
INSERT INTO `city` VALUES ('150','枣庄市');
INSERT INTO `city` VALUES ('151','东营市');
INSERT INTO `city` VALUES ('152','烟台市');
INSERT INTO `city` VALUES ('153','潍坊市');
INSERT INTO `city` VALUES ('154','济宁市');
INSERT INTO `city` VALUES ('155','泰安市');
INSERT INTO `city` VALUES ('156','威海市');
INSERT INTO `city` VALUES ('157','日照市');
INSERT INTO `city` VALUES ('158','莱芜市');
INSERT INTO `city` VALUES ('159','临沂市');
INSERT INTO `city` VALUES ('160','德州市');
INSERT INTO `city` VALUES ('161','聊城市');
INSERT INTO `city` VALUES ('162','滨州市');
INSERT INTO `city` VALUES ('163','菏泽市');
INSERT INTO `city` VALUES ('164','郑州市');
INSERT INTO `city` VALUES ('165','开封市');
INSERT INTO `city` VALUES ('166','洛阳市');
INSERT INTO `city` VALUES ('167','平顶山市');
INSERT INTO `city` VALUES ('168','安阳市');
INSERT INTO `city` VALUES ('169','鹤壁市');
INSERT INTO `city` VALUES ('170','新乡市');
INSERT INTO `city` VALUES ('171','焦作市');
INSERT INTO `city` VALUES ('172','濮阳市');
INSERT INTO `city` VALUES ('173','许昌市');
INSERT INTO `city` VALUES ('174','漯河市');
INSERT INTO `city` VALUES ('175','三门峡市');
INSERT INTO `city` VALUES ('176','南阳市');
INSERT INTO `city` VALUES ('177','商丘市');
INSERT INTO `city` VALUES ('178','信阳市');
INSERT INTO `city` VALUES ('179','周口市');
INSERT INTO `city` VALUES ('180','驻马店市');
INSERT INTO `city` VALUES ('181','济源市');
INSERT INTO `city` VALUES ('182','武汉市');
INSERT INTO `city` VALUES ('183','黄石市');
INSERT INTO `city` VALUES ('184','十堰市');
INSERT INTO `city` VALUES ('185','荆州市');
INSERT INTO `city` VALUES ('186','宜昌市');
INSERT INTO `city` VALUES ('187','襄樊市');
INSERT INTO `city` VALUES ('188','鄂州市');
INSERT INTO `city` VALUES ('189','荆门市');
INSERT INTO `city` VALUES ('190','孝感市');
INSERT INTO `city` VALUES ('191','黄冈市');
INSERT INTO `city` VALUES ('192','咸宁市');
INSERT INTO `city` VALUES ('193','随州市');
INSERT INTO `city` VALUES ('194','仙桃市');
INSERT INTO `city` VALUES ('195','天门市');
INSERT INTO `city` VALUES ('196','潜江市');
INSERT INTO `city` VALUES ('197','神农架林区');
INSERT INTO `city` VALUES ('198','恩施土家族苗族自治州');
INSERT INTO `city` VALUES ('199','长沙市');
INSERT INTO `city` VALUES ('200','株洲市');
INSERT INTO `city` VALUES ('201','湘潭市');
INSERT INTO `city` VALUES ('202','衡阳市');
INSERT INTO `city` VALUES ('203','邵阳市');
INSERT INTO `city` VALUES ('204','岳阳市');
INSERT INTO `city` VALUES ('205','常德市');
INSERT INTO `city` VALUES ('206','张家界市');
INSERT INTO `city` VALUES ('207','益阳市');
INSERT INTO `city` VALUES ('208','郴州市');
INSERT INTO `city` VALUES ('209','永州市');
INSERT INTO `city` VALUES ('210','怀化市');
INSERT INTO `city` VALUES ('211','娄底市');
INSERT INTO `city` VALUES ('212','湘西土家族苗族自治州');
INSERT INTO `city` VALUES ('213','广州市');
INSERT INTO `city` VALUES ('214','深圳市');
INSERT INTO `city` VALUES ('215','珠海市');
INSERT INTO `city` VALUES ('216','汕头市');
INSERT INTO `city` VALUES ('217','韶关市');
INSERT INTO `city` VALUES ('218','佛山市');
INSERT INTO `city` VALUES ('219','江门市');
INSERT INTO `city` VALUES ('220','湛江市');
INSERT INTO `city` VALUES ('221','茂名市');
INSERT INTO `city` VALUES ('222','肇庆市');
INSERT INTO `city` VALUES ('223','惠州市');
INSERT INTO `city` VALUES ('224','梅州市');
INSERT INTO `city` VALUES ('225','汕尾市');
INSERT INTO `city` VALUES ('226','河源市');
INSERT INTO `city` VALUES ('227','阳江市');
INSERT INTO `city` VALUES ('228','清远市');
INSERT INTO `city` VALUES ('229','东莞市');
INSERT INTO `city` VALUES ('230','中山市');
INSERT INTO `city` VALUES ('231','潮州市');
INSERT INTO `city` VALUES ('232','揭阳市');
INSERT INTO `city` VALUES ('233','云浮市');
INSERT INTO `city` VALUES ('234','兰州市');
INSERT INTO `city` VALUES ('235','金昌市');
INSERT INTO `city` VALUES ('236','白银市');
INSERT INTO `city` VALUES ('237','天水市');
INSERT INTO `city` VALUES ('238','嘉峪关市');
INSERT INTO `city` VALUES ('239','武威市');
INSERT INTO `city` VALUES ('240','张掖市');
INSERT INTO `city` VALUES ('241','平凉市');
INSERT INTO `city` VALUES ('242','酒泉市');
INSERT INTO `city` VALUES ('243','庆阳市');
INSERT INTO `city` VALUES ('244','定西市');
INSERT INTO `city` VALUES ('245','陇南市');
INSERT INTO `city` VALUES ('246','临夏回族自治州');
INSERT INTO `city` VALUES ('247','甘南藏族自治州');
INSERT INTO `city` VALUES ('248','成都市');
INSERT INTO `city` VALUES ('249','自贡市');
INSERT INTO `city` VALUES ('250','攀枝花市');
INSERT INTO `city` VALUES ('251','泸州市');
INSERT INTO `city` VALUES ('252','德阳市');
INSERT INTO `city` VALUES ('253','绵阳市');
INSERT INTO `city` VALUES ('254','广元市');
INSERT INTO `city` VALUES ('255','遂宁市');
INSERT INTO `city` VALUES ('256','内江市');
INSERT INTO `city` VALUES ('257','乐山市');
INSERT INTO `city` VALUES ('258','南充市');
INSERT INTO `city` VALUES ('259','眉山市');
INSERT INTO `city` VALUES ('260','宜宾市');
INSERT INTO `city` VALUES ('261','广安市');
INSERT INTO `city` VALUES ('262','达州市');
INSERT INTO `city` VALUES ('263','雅安市');
INSERT INTO `city` VALUES ('264','巴中市');
INSERT INTO `city` VALUES ('265','资阳市');
INSERT INTO `city` VALUES ('266','阿坝藏族羌族自治州');
INSERT INTO `city` VALUES ('267','甘孜藏族自治州');
INSERT INTO `city` VALUES ('268','凉山彝族自治州');
INSERT INTO `city` VALUES ('269','贵阳市');
INSERT INTO `city` VALUES ('270','六盘水市');
INSERT INTO `city` VALUES ('271','遵义市');
INSERT INTO `city` VALUES ('272','安顺市');
INSERT INTO `city` VALUES ('273','铜仁地区');
INSERT INTO `city` VALUES ('274','毕节地区');
INSERT INTO `city` VALUES ('275','黔西南布依族苗族自治州');
INSERT INTO `city` VALUES ('276','黔东南苗族侗族自治州');
INSERT INTO `city` VALUES ('277','黔南布依族苗族自治州');
INSERT INTO `city` VALUES ('278','24','海口市');
INSERT INTO `city` VALUES ('279','三亚市');
INSERT INTO `city` VALUES ('280','五指山市');
INSERT INTO `city` VALUES ('281','琼海市');
INSERT INTO `city` VALUES ('282','儋州市');
INSERT INTO `city` VALUES ('283','文昌市');
INSERT INTO `city` VALUES ('284','万宁市');
INSERT INTO `city` VALUES ('285','东方市');
INSERT INTO `city` VALUES ('286','澄迈县');
INSERT INTO `city` VALUES ('287','定安县');
INSERT INTO `city` VALUES ('288','屯昌县');
INSERT INTO `city` VALUES ('289','临高县');
INSERT INTO `city` VALUES ('290','白沙黎族自治县');
INSERT INTO `city` VALUES ('291','昌江黎族自治县');
INSERT INTO `city` VALUES ('292','乐东黎族自治县');
INSERT INTO `city` VALUES ('293','陵水黎族自治县');
INSERT INTO `city` VALUES ('294','保亭黎族苗族自治县');
INSERT INTO `city` VALUES ('295','琼中黎族苗族自治县');
INSERT INTO `city` VALUES ('296','25','昆明市');
INSERT INTO `city` VALUES ('297','曲靖市');
INSERT INTO `city` VALUES ('298','玉溪市');
INSERT INTO `city` VALUES ('299','保山市');
INSERT INTO `city` VALUES ('300','昭通市');
INSERT INTO `city` VALUES ('301','丽江市');
INSERT INTO `city` VALUES ('302','思茅市');
INSERT INTO `city` VALUES ('303','临沧市');
INSERT INTO `city` VALUES ('304','文山壮族苗族自治州');
INSERT INTO `city` VALUES ('305','红河哈尼族彝族自治州');
INSERT INTO `city` VALUES ('306','西双版纳傣族自治州');
INSERT INTO `city` VALUES ('307','楚雄彝族自治州');
INSERT INTO `city` VALUES ('308','大理白族自治州');
INSERT INTO `city` VALUES ('309','德宏傣族景颇族自治州');
INSERT INTO `city` VALUES ('310','怒江傈傈族自治州');
INSERT INTO `city` VALUES ('311','迪庆藏族自治州');
INSERT INTO `city` VALUES ('312','26','西宁市');
INSERT INTO `city` VALUES ('313','海东地区');
INSERT INTO `city` VALUES ('314','海北藏族自治州');
INSERT INTO `city` VALUES ('315','黄南藏族自治州');
INSERT INTO `city` VALUES ('316','海南藏族自治州');
INSERT INTO `city` VALUES ('317','果洛藏族自治州');
INSERT INTO `city` VALUES ('318','玉树藏族自治州');
INSERT INTO `city` VALUES ('319','海西蒙古族藏族自治州');
INSERT INTO `city` VALUES ('320','27','西安市');
INSERT INTO `city` VALUES ('321','铜川市');
INSERT INTO `city` VALUES ('322','宝鸡市');
INSERT INTO `city` VALUES ('323','咸阳市');
INSERT INTO `city` VALUES ('324','渭南市');
INSERT INTO `city` VALUES ('325','延安市');
INSERT INTO `city` VALUES ('326','汉中市');
INSERT INTO `city` VALUES ('327','榆林市');
INSERT INTO `city` VALUES ('328','安康市');
INSERT INTO `city` VALUES ('329','商洛市');
INSERT INTO `city` VALUES ('330','28','南宁市');
INSERT INTO `city` VALUES ('331','柳州市');
INSERT INTO `city` VALUES ('332','桂林市');
INSERT INTO `city` VALUES ('333','梧州市');
INSERT INTO `city` VALUES ('334','北海市');
INSERT INTO `city` VALUES ('335','防城港市');
INSERT INTO `city` VALUES ('336','钦州市');
INSERT INTO `city` VALUES ('337','贵港市');
INSERT INTO `city` VALUES ('338','玉林市');
INSERT INTO `city` VALUES ('339','百色市');
INSERT INTO `city` VALUES ('340','贺州市');
INSERT INTO `city` VALUES ('341','河池市');
INSERT INTO `city` VALUES ('342','来宾市');
INSERT INTO `city` VALUES ('343','崇左市');
INSERT INTO `city` VALUES ('344','29','拉萨市');
INSERT INTO `city` VALUES ('345','那曲地区');
INSERT INTO `city` VALUES ('346','昌都地区');
INSERT INTO `city` VALUES ('347','山南地区');
INSERT INTO `city` VALUES ('348','日喀则地区');
INSERT INTO `city` VALUES ('349','阿里地区');
INSERT INTO `city` VALUES ('350','林芝地区');
INSERT INTO `city` VALUES ('351','30','银川市');
INSERT INTO `city` VALUES ('352','石嘴山市');
INSERT INTO `city` VALUES ('353','吴忠市');
INSERT INTO `city` VALUES ('354','固原市');
INSERT INTO `city` VALUES ('355','中卫市');
INSERT INTO `city` VALUES ('356','31','乌鲁木齐市');
INSERT INTO `city` VALUES ('357','克拉玛依市');
INSERT INTO `city` VALUES ('358','石河子市　');
INSERT INTO `city` VALUES ('359','阿拉尔市');
INSERT INTO `city` VALUES ('360','图木舒克市');
INSERT INTO `city` VALUES ('361','五家渠市');
INSERT INTO `city` VALUES ('362','吐鲁番市');
INSERT INTO `city` VALUES ('363','阿克苏市');
INSERT INTO `city` VALUES ('364','喀什市');
INSERT INTO `city` VALUES ('365','哈密市');
INSERT INTO `city` VALUES ('366','和田市');
INSERT INTO `city` VALUES ('367','阿图什市');
INSERT INTO `city` VALUES ('368','库尔勒市');
INSERT INTO `city` VALUES ('369','昌吉市　');
INSERT INTO `city` VALUES ('370','阜康市');
INSERT INTO `city` VALUES ('371','米泉市');
INSERT INTO `city` VALUES ('372','博乐市');
INSERT INTO `city` VALUES ('373','伊宁市');
INSERT INTO `city` VALUES ('374','奎屯市');
INSERT INTO `city` VALUES ('375','塔城市');
INSERT INTO `city` VALUES ('376','乌苏市');
INSERT INTO `city` VALUES ('377','阿勒泰市');
INSERT INTO `city` VALUES ('378','32','呼和浩特市');
INSERT INTO `city` VALUES ('379','包头市');
INSERT INTO `city` VALUES ('380','乌海市');
INSERT INTO `city` VALUES ('381','赤峰市');
INSERT INTO `city` VALUES ('382','通辽市');
INSERT INTO `city` VALUES ('383','鄂尔多斯市');
INSERT INTO `city` VALUES ('384','呼伦贝尔市');
INSERT INTO `city` VALUES ('385','巴彦淖尔市');
INSERT INTO `city` VALUES ('386','乌兰察布市');
INSERT INTO `city` VALUES ('387','锡林郭勒盟');
INSERT INTO `city` VALUES ('388','兴安盟');
INSERT INTO `city` VALUES ('389','阿拉善盟');
INSERT INTO `city` VALUES ('390','33','澳门特别行政区');
INSERT INTO `city` VALUES ('391','34','香港特别行政区');

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!