当前位置：搜档网 › 全国省市县SQL数据库(大全)

全国省市县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');

INSERT INTO `city` VALUES ('34' '1' '澳门' '1'); INSERT INTO `city` VALUES ('35' '1' '台湾' '1'); INSERT INTO `city` VALUES ('36' '3' '安庆' '2'); INSERT INTO `city` VALUES ('37' '3' '蚌埠' '2'); INSERT INTO `city` VALUES ('38' '3' '巢湖' '2'); INSERT INTO `city` VALUES ('39' '3' '池州' '2'); INSERT INTO `city` VALUES ('40' '3' '滁州' '2'); INSERT INTO `city` VALUES ('41' '3' '阜阳' '2'); INSERT INTO `city` VALUES ('42' '3' '淮北' '2'); INSERT INTO `city` VALUES ('43' '3' '淮南' '2'); INSERT INTO `city` VALUES ('44' '3' '黄山' '2'); INSERT INTO `city` VALUES ('45' '3' '六安' '2'); INSERT INTO `city` VALUES ('46' '3' '马鞍山' '2'); INSERT INTO `city` VALUES ('47' '3' '宿州' '2'); INSERT INTO `city` VALUES ('48' '3' '铜陵' '2'); INSERT INTO `city` VALUES ('49' '3' '芜湖' '2'); INSERT INTO `city` VALUES ('50' '3' '宣城' '2'); INSERT INTO `city` VALUES ('51' '3' '亳州' '2'); INSERT INTO `city` VALUES ('52' '2' '市辖区' '2'); INSERT INTO `city` VALUES ('53' '4' '福州' '2'); INSERT INTO `city` VALUES ('54' '4' '龙岩' '2'); INSERT INTO `city` VALUES ('55' '4' '南平' '2'); INSERT INTO `city` VALUES ('56' '4' '宁德' '2'); INSERT INTO `city` VALUES ('57' '4' '莆田' '2'); INSERT INTO `city` VALUES ('58' '4' '泉州' '2'); INSERT INTO `city` VALUES ('59' '4' '三明' '2'); INSERT INTO `city` VALUES ('60' '4' '厦门' '2'); INSERT INTO `city` VALUES ('61' '4' '漳州' '2'); INSERT INTO `city` VALUES ('62' '5' '兰州' '2'); INSERT INTO `city` VALUES ('63' '5' '白银' '2'); INSERT INTO `city` VALUES ('64' '5' '定西' '2'); INSERT INTO `city` VALUES ('65' '5' '甘南' '2'); INSERT INTO `city` VALUES ('66' '5' '嘉峪关' '2'); INSERT INTO `city` VALUES ('67' '5' '金昌' '2'); INSERT INTO `city` VALUES ('68' '5' '酒泉' '2'); INSERT INTO `city` VALUES ('69' '5' '临夏' '2'); INSERT INTO `city` VALUES ('70' '5' '陇南' '2'); INSERT INTO `city` VALUES ('71' '5' '平凉' '2'); INSERT INTO `city` VALUES ('72' '5' '庆阳' '2');

INSERT INTO `city` VALUES ('74' '5' '武威' '2'); INSERT INTO `city` VALUES ('75' '5' '张掖' '2'); INSERT INTO `city` VALUES ('76' '6' '广州' '2'); INSERT INTO `city` VALUES ('77' '6' '深圳' '2'); INSERT INTO `city` VALUES ('78' '6' '潮州' '2'); INSERT INTO `city` VALUES ('79' '6' '东莞' '2'); INSERT INTO `city` VALUES ('80' '6' '佛山' '2'); INSERT INTO `city` VALUES ('81' '6' '河源' '2'); INSERT INTO `city` VALUES ('82' '6' '惠州' '2'); INSERT INTO `city` VALUES ('83' '6' '江门' '2'); INSERT INTO `city` VALUES ('84' '6' '揭阳' '2'); INSERT INTO `city` VALUES ('85' '6' '茂名' '2'); INSERT INTO `city` VALUES ('86' '6' '梅州' '2'); INSERT INTO `city` VALUES ('87' '6' '清远' '2'); INSERT INTO `city` VALUES ('88' '6' '汕头' '2'); INSERT INTO `city` VALUES ('89' '6' '汕尾' '2'); INSERT INTO `city` VALUES ('90' '6' '韶关' '2'); INSERT INTO `city` VALUES ('91' '6' '阳江' '2'); INSERT INTO `city` VALUES ('92' '6' '云浮' '2'); INSERT INTO `city` VALUES ('93' '6' '湛江' '2'); INSERT INTO `city` VALUES ('94' '6' '肇庆' '2'); INSERT INTO `city` VALUES ('95' '6' '中山' '2'); INSERT INTO `city` VALUES ('96' '6' '珠海' '2'); INSERT INTO `city` VALUES ('97' '7' '南宁' '2'); INSERT INTO `city` VALUES ('98' '7' '桂林' '2'); INSERT INTO `city` VALUES ('99' '7' '百色' '2'); INSERT INTO `city` VALUES ('100' '7' '北海' '2'); INSERT INTO `city` VALUES ('101' '7' '崇左' '2'); INSERT INTO `city` VALUES ('102' '7' '防城港' '2'); INSERT INTO `city` VALUES ('103' '7' '贵港' '2'); INSERT INTO `city` VALUES ('104' '7' '河池' '2'); INSERT INTO `city` VALUES ('105' '7' '贺州' '2'); INSERT INTO `city` VALUES ('106' '7' '来宾' '2'); INSERT INTO `city` VALUES ('107' '7' '柳州' '2'); INSERT INTO `city` VALUES ('108' '7' '钦州' '2'); INSERT INTO `city` VALUES ('109' '7' '梧州' '2'); INSERT INTO `city` VALUES ('110' '7' '玉林' '2'); INSERT INTO `city` VALUES ('111' '8' '贵阳' '2'); INSERT INTO `city` VALUES ('112' '8' '安顺' '2');

INSERT INTO `city` VALUES ('114' '8' '六盘水' '2'); INSERT INTO `city` VALUES ('115' '8' '黔东南' '2'); INSERT INTO `city` VALUES ('116' '8' '黔南' '2'); INSERT INTO `city` VALUES ('117' '8' '黔西南' '2'); INSERT INTO `city` VALUES ('118' '8' '铜仁' '2'); INSERT INTO `city` VALUES ('119' '8' '遵义' '2'); INSERT INTO `city` VALUES ('120' '9' '海口' '2'); INSERT INTO `city` VALUES ('121' '9' '三亚' '2'); INSERT INTO `city` VALUES ('122' '9' '白沙' '2'); INSERT INTO `city` VALUES ('123' '9' '保亭' '2'); INSERT INTO `city` VALUES ('124' '9' '昌江' '2'); INSERT INTO `city` VALUES ('125' '9' '澄迈县' '2'); INSERT INTO `city` VALUES ('126' '9' '定安县' '2'); INSERT INTO `city` VALUES ('127' '9' '东方' '2'); INSERT INTO `city` VALUES ('128' '9' '乐东' '2'); INSERT INTO `city` VALUES ('129' '9' '临高县' '2'); INSERT INTO `city` VALUES ('130' '9' '陵水' '2'); INSERT INTO `city` VALUES ('131' '9' '琼海' '2'); INSERT INTO `city` VALUES ('132' '9' '琼中' '2'); INSERT INTO `city` VALUES ('133' '9' '屯昌县' '2'); INSERT INTO `city` VALUES ('134' '9' '万宁' '2'); INSERT INTO `city` VALUES ('135' '9' '文昌' '2'); INSERT INTO `city` VALUES ('136' '9' '五指山' '2'); INSERT INTO `city` VALUES ('137' '9' '儋州' '2'); INSERT INTO `city` VALUES ('138' '10' '石家庄' '2'); INSERT INTO `city` VALUES ('139' '10' '保定' '2'); INSERT INTO `city` VALUES ('140' '10' '沧州' '2'); INSERT INTO `city` VALUES ('141' '10' '承德' '2'); INSERT INTO `city` VALUES ('142' '10' '邯郸' '2'); INSERT INTO `city` VALUES ('143' '10' '衡水' '2'); INSERT INTO `city` VALUES ('144' '10' '廊坊' '2'); INSERT INTO `city` VALUES ('145' '10' '秦皇岛' '2'); INSERT INTO `city` VALUES ('146' '10' '唐山' '2'); INSERT INTO `city` VALUES ('147' '10' '邢台' '2'); INSERT INTO `city` VALUES ('148' '10' '张家口' '2'); INSERT INTO `city` VALUES ('149' '11' '郑州' '2'); INSERT INTO `city` VALUES ('150' '11' '洛阳' '2'); INSERT INTO `city` VALUES ('151' '11' '开封' '2'); INSERT INTO `city` VALUES ('152' '11' '安阳' '2');

INSERT INTO `city` VALUES ('154' '11' '济源' '2'); INSERT INTO `city` VALUES ('155' '11' '焦作' '2'); INSERT INTO `city` VALUES ('156' '11' '南阳' '2'); INSERT INTO `city` VALUES ('157' '11' '平顶山' '2'); INSERT INTO `city` VALUES ('158' '11' '三门峡' '2'); INSERT INTO `city` VALUES ('159' '11' '商丘' '2'); INSERT INTO `city` VALUES ('160' '11' '新乡' '2'); INSERT INTO `city` VALUES ('161' '11' '信阳' '2'); INSERT INTO `city` VALUES ('162' '11' '许昌' '2'); INSERT INTO `city` VALUES ('163' '11' '周口' '2'); INSERT INTO `city` VALUES ('164' '11' '驻马店' '2'); INSERT INTO `city` VALUES ('165' '11' '漯河' '2'); INSERT INTO `city` VALUES ('166' '11' '濮阳' '2'); INSERT INTO `city` VALUES ('167' '12' '哈尔滨' '2'); INSERT INTO `city` VALUES ('168' '12' '大庆' '2'); INSERT INTO `city` VALUES ('169' '12' '大兴安岭' '2'); INSERT INTO `city` VALUES ('170' '12' '鹤岗' '2'); INSERT INTO `city` VALUES ('171' '12' '黑河' '2'); INSERT INTO `city` VALUES ('172' '12' '鸡西' '2'); INSERT INTO `city` VALUES ('173' '12' '佳木斯' '2'); INSERT INTO `city` VALUES ('174' '12' '牡丹江' '2'); INSERT INTO `city` VALUES ('175' '12' '七台河' '2'); INSERT INTO `city` VALUES ('176' '12' '齐齐哈尔' '2'); INSERT INTO `city` VALUES ('177' '12' '双鸭山' '2'); INSERT INTO `city` VALUES ('178' '12' '绥化' '2'); INSERT INTO `city` VALUES ('179' '12' '伊春' '2'); INSERT INTO `city` VALUES ('180' '13' '武汉' '2'); INSERT INTO `city` VALUES ('181' '13' '仙桃' '2'); INSERT INTO `city` VALUES ('182' '13' '鄂州' '2'); INSERT INTO `city` VALUES ('183' '13' '黄冈' '2'); INSERT INTO `city` VALUES ('184' '13' '黄石' '2'); INSERT INTO `city` VALUES ('185' '13' '荆门' '2'); INSERT INTO `city` VALUES ('186' '13' '荆州' '2'); INSERT INTO `city` VALUES ('187' '13' '潜江' '2'); INSERT INTO `city` VALUES ('188' '13' '神农架林区' '2'); INSERT INTO `city` VALUES ('189' '13' '十堰' '2'); INSERT INTO `city` VALUES ('190' '13' '随州' '2'); INSERT INTO `city` VALUES ('191' '13' '天门' '2'); INSERT INTO `city` VALUES ('192' '13' '咸宁' '2');

INSERT INTO `city` VALUES ('194' '13' '孝感' '2'); INSERT INTO `city` VALUES ('195' '13' '宜昌' '2'); INSERT INTO `city` VALUES ('196' '13' '恩施' '2'); INSERT INTO `city` VALUES ('197' '14' '长沙' '2'); INSERT INTO `city` VALUES ('198' '14' '张家界' '2'); INSERT INTO `city` VALUES ('199' '14' '常德' '2'); INSERT INTO `city` VALUES ('200' '14' '郴州' '2'); INSERT INTO `city` VALUES ('201' '14' '衡阳' '2'); INSERT INTO `city` VALUES ('202' '14' '怀化' '2'); INSERT INTO `city` VALUES ('203' '14' '娄底' '2'); INSERT INTO `city` VALUES ('204' '14' '邵阳' '2'); INSERT INTO `city` VALUES ('205' '14' '湘潭' '2'); INSERT INTO `city` VALUES ('206' '14' '湘西' '2'); INSERT INTO `city` VALUES ('207' '14' '益阳' '2'); INSERT INTO `city` VALUES ('208' '14' '永州' '2'); INSERT INTO `city` VALUES ('209' '14' '岳阳' '2'); INSERT INTO `city` VALUES ('210' '14' '株洲' '2'); INSERT INTO `city` VALUES ('211' '15' '长春' '2'); INSERT INTO `city` VALUES ('212' '15' '吉林' '2'); INSERT INTO `city` VALUES ('213' '15' '白城' '2'); INSERT INTO `city` VALUES ('214' '15' '白山' '2'); INSERT INTO `city` VALUES ('215' '15' '辽源' '2'); INSERT INTO `city` VALUES ('216' '15' '四平' '2'); INSERT INTO `city` VALUES ('217' '15' '松原' '2'); INSERT INTO `city` VALUES ('218' '15' '通化' '2'); INSERT INTO `city` VALUES ('219' '15' '延边' '2'); INSERT INTO `city` VALUES ('220' '16' '南京' '2'); INSERT INTO `city` VALUES ('221' '16' '苏州' '2'); INSERT INTO `city` VALUES ('222' '16' '无锡' '2'); INSERT INTO `city` VALUES ('223' '16' '常州' '2'); INSERT INTO `city` VALUES ('224' '16' '淮安' '2'); INSERT INTO `city` VALUES ('225' '16' '连云港' '2'); INSERT INTO `city` VALUES ('226' '16' '南通' '2'); INSERT INTO `city` VALUES ('227' '16' '宿迁' '2'); INSERT INTO `city` VALUES ('228' '16' '泰州' '2'); INSERT INTO `city` VALUES ('229' '16' '徐州' '2'); INSERT INTO `city` VALUES ('230' '16' '盐城' '2'); INSERT INTO `city` VALUES ('231' '16' '扬州' '2'); INSERT INTO `city` VALUES ('232' '16' '镇江' '2');

INSERT INTO `city` VALUES ('234' '17' '抚州' '2'); INSERT INTO `city` VALUES ('235' '17' '赣州' '2'); INSERT INTO `city` VALUES ('236' '17' '吉安' '2'); INSERT INTO `city` VALUES ('237' '17' '景德镇' '2'); INSERT INTO `city` VALUES ('238' '17' '九江' '2'); INSERT INTO `city` VALUES ('239' '17' '萍乡' '2'); INSERT INTO `city` VALUES ('240' '17' '上饶' '2'); INSERT INTO `city` VALUES ('241' '17' '新余' '2'); INSERT INTO `city` VALUES ('242' '17' '宜春' '2'); INSERT INTO `city` VALUES ('243' '17' '鹰潭' '2'); INSERT INTO `city` VALUES ('244' '18' '沈阳' '2'); INSERT INTO `city` VALUES ('245' '18' '大连' '2'); INSERT INTO `city` VALUES ('246' '18' '鞍山' '2'); INSERT INTO `city` VALUES ('247' '18' '本溪' '2'); INSERT INTO `city` VALUES ('248' '18' '朝阳' '2'); INSERT INTO `city` VALUES ('249' '18' '丹东' '2'); INSERT INTO `city` VALUES ('250' '18' '抚顺' '2'); INSERT INTO `city` VALUES ('251' '18' '阜新' '2'); INSERT INTO `city` VALUES ('252' '18' '葫芦岛' '2'); INSERT INTO `city` VALUES ('253' '18' '锦州' '2'); INSERT INTO `city` VALUES ('254' '18' '辽阳' '2'); INSERT INTO `city` VALUES ('255' '18' '盘锦' '2'); INSERT INTO `city` VALUES ('256' '18' '铁岭' '2'); INSERT INTO `city` VALUES ('257' '18' '营口' '2'); INSERT INTO `city` VALUES ('258' '19' '呼和浩特' '2'); INSERT INTO `city` VALUES ('259' '19' '阿拉善盟' '2'); INSERT INTO `city` VALUES ('260' '19' '巴彦淖尔盟' '2'); INSERT INTO `city` VALUES ('261' '19' '包头' '2'); INSERT INTO `city` VALUES ('262' '19' '赤峰' '2'); INSERT INTO `city` VALUES ('263' '19' '鄂尔多斯' '2'); INSERT INTO `city` VALUES ('264' '19' '呼伦贝尔' '2'); INSERT INTO `city` VALUES ('265' '19' '通辽' '2'); INSERT INTO `city` VALUES ('266' '19' '乌海' '2'); INSERT INTO `city` VALUES ('267' '19' '乌兰察布市' '2'); INSERT INTO `city` VALUES ('268' '19' '锡林郭勒盟' '2'); INSERT INTO `city` VALUES ('269' '19' '兴安盟' '2'); INSERT INTO `city` VALUES ('270' '20' '银川' '2'); INSERT INTO `city` VALUES ('271' '20' '固原' '2'); INSERT INTO `city` VALUES ('272' '20' '石嘴山' '2');

INSERT INTO `city` VALUES ('274' '20' '中卫' '2'); INSERT INTO `city` VALUES ('275' '21' '西宁' '2'); INSERT INTO `city` VALUES ('276' '21' '果洛' '2'); INSERT INTO `city` VALUES ('277' '21' '海北' '2'); INSERT INTO `city` VALUES ('278' '21' '海东' '2'); INSERT INTO `city` VALUES ('279' '21' '海南' '2'); INSERT INTO `city` VALUES ('280' '21' '海西' '2'); INSERT INTO `city` VALUES ('281' '21' '黄南' '2'); INSERT INTO `city` VALUES ('282' '21' '玉树' '2'); INSERT INTO `city` VALUES ('283' '22' '济南' '2'); INSERT INTO `city` VALUES ('284' '22' '青岛' '2'); INSERT INTO `city` VALUES ('285' '22' '滨州' '2'); INSERT INTO `city` VALUES ('286' '22' '德州' '2'); INSERT INTO `city` VALUES ('287' '22' '东营' '2'); INSERT INTO `city` VALUES ('288' '22' '菏泽' '2'); INSERT INTO `city` VALUES ('289' '22' '济宁' '2'); INSERT INTO `city` VALUES ('290' '22' '莱芜' '2'); INSERT INTO `city` VALUES ('291' '22' '聊城' '2'); INSERT INTO `city` VALUES ('292' '22' '临沂' '2'); INSERT INTO `city` VALUES ('293' '22' '日照' '2'); INSERT INTO `city` VALUES ('294' '22' '泰安' '2'); INSERT INTO `city` VALUES ('295' '22' '威海' '2'); INSERT INTO `city` VALUES ('296' '22' '潍坊' '2'); INSERT INTO `city` VALUES ('297' '22' '烟台' '2'); INSERT INTO `city` VALUES ('298' '22' '枣庄' '2'); INSERT INTO `city` VALUES ('299' '22' '淄博' '2'); INSERT INTO `city` VALUES ('300' '23' '太原' '2'); INSERT INTO `city` VALUES ('301' '23' '长治' '2'); INSERT INTO `city` VALUES ('302' '23' '大同' '2'); INSERT INTO `city` VALUES ('303' '23' '晋城' '2'); INSERT INTO `city` VALUES ('304' '23' '晋中' '2'); INSERT INTO `city` VALUES ('305' '23' '临汾' '2'); INSERT INTO `city` VALUES ('306' '23' '吕梁' '2'); INSERT INTO `city` VALUES ('307' '23' '朔州' '2'); INSERT INTO `city` VALUES ('308' '23' '忻州' '2'); INSERT INTO `city` VALUES ('309' '23' '阳泉' '2'); INSERT INTO `city` VALUES ('310' '23' '运城' '2'); INSERT INTO `city` VALUES ('311' '24' '西安' '2'); INSERT INTO `city` VALUES ('312' '24' '安康' '2');

INSERT INTO `city` VALUES ('314' '24' '汉中' '2'); INSERT INTO `city` VALUES ('315' '24' '商洛' '2'); INSERT INTO `city` VALUES ('316' '24' '铜川' '2'); INSERT INTO `city` VALUES ('317' '24' '渭南' '2'); INSERT INTO `city` VALUES ('318' '24' '咸阳' '2'); INSERT INTO `city` VALUES ('319' '24' '延安' '2'); INSERT INTO `city` VALUES ('320' '24' '榆林' '2'); INSERT INTO `city` VALUES ('321' '25' '上海' '2'); INSERT INTO `city` VALUES ('322' '26' '成都' '2'); INSERT INTO `city` VALUES ('323' '26' '绵阳' '2'); INSERT INTO `city` VALUES ('324' '26' '阿坝' '2'); INSERT INTO `city` VALUES ('325' '26' '巴中' '2'); INSERT INTO `city` VALUES ('326' '26' '达州' '2'); INSERT INTO `city` VALUES ('327' '26' '德阳' '2'); INSERT INTO `city` VALUES ('328' '26' '甘孜' '2'); INSERT INTO `city` VALUES ('329' '26' '广安' '2'); INSERT INTO `city` VALUES ('330' '26' '广元' '2'); INSERT INTO `city` VALUES ('331' '26' '乐山' '2'); INSERT INTO `city` VALUES ('332' '26' '凉山' '2'); INSERT INTO `city` VALUES ('333' '26' '眉山' '2'); INSERT INTO `city` VALUES ('334' '26' '南充' '2'); INSERT INTO `city` VALUES ('335' '26' '内江' '2'); INSERT INTO `city` VALUES ('336' '26' '攀枝花' '2'); INSERT INTO `city` VALUES ('337' '26' '遂宁' '2'); INSERT INTO `city` VALUES ('338' '26' '雅安' '2'); INSERT INTO `city` VALUES ('339' '26' '宜宾' '2'); INSERT INTO `city` VALUES ('340' '26' '资阳' '2'); INSERT INTO `city` VALUES ('341' '26' '自贡' '2'); INSERT INTO `city` VALUES ('342' '26' '泸州' '2'); INSERT INTO `city` VALUES ('343' '27' '天津' '2'); INSERT INTO `city` VALUES ('344' '28' '拉萨' '2'); INSERT INTO `city` VALUES ('345' '28' '阿里' '2'); INSERT INTO `city` VALUES ('346' '28' '昌都' '2'); INSERT INTO `city` VALUES ('347' '28' '林芝' '2'); INSERT INTO `city` VALUES ('348' '28' '那曲' '2'); INSERT INTO `city` VALUES ('349' '28' '日喀则' '2'); INSERT INTO `city` VALUES ('350' '28' '山南' '2'); INSERT INTO `city` VALUES ('351' '29' '乌鲁木齐' '2'); INSERT INTO `city` VALUES ('352' '29' '阿克苏' '2');

INSERT INTO `city` VALUES ('354' '29' '巴音郭楞' '2'); INSERT INTO `city` VALUES ('355' '29' '博尔塔拉' '2'); INSERT INTO `city` VALUES ('356' '29' '昌吉' '2'); INSERT INTO `city` VALUES ('357' '29' '哈密' '2'); INSERT INTO `city` VALUES ('358' '29' '和田' '2'); INSERT INTO `city` VALUES ('359' '29' '喀什' '2'); INSERT INTO `city` VALUES ('360' '29' '克拉玛依' '2'); INSERT INTO `city` VALUES ('361' '29' '克孜勒苏' '2'); INSERT INTO `city` VALUES ('362' '29' '石河子' '2'); INSERT INTO `city` VALUES ('363' '29' '图木舒克' '2'); INSERT INTO `city` VALUES ('364' '29' '吐鲁番' '2'); INSERT INTO `city` VALUES ('365' '29' '五家渠' '2'); INSERT INTO `city` VALUES ('366' '29' '伊犁' '2'); INSERT INTO `city` VALUES ('367' '30' '昆明' '2'); INSERT INTO `city` VALUES ('368' '30' '怒江' '2'); INSERT INTO `city` VALUES ('369' '30' '普洱' '2'); INSERT INTO `city` VALUES ('370' '30' '丽江' '2'); INSERT INTO `city` VALUES ('371' '30' '保山' '2'); INSERT INTO `city` VALUES ('372' '30' '楚雄' '2'); INSERT INTO `city` VALUES ('373' '30' '大理' '2'); INSERT INTO `city` VALUES ('374' '30' '德宏' '2'); INSERT INTO `city` VALUES ('375' '30' '迪庆' '2'); INSERT INTO `city` VALUES ('376' '30' '红河' '2'); INSERT INTO `city` VALUES ('377' '30' '临沧' '2'); INSERT INTO `city` VALUES ('378' '30' '曲靖' '2'); INSERT INTO `city` VALUES ('379' '30' '文山' '2'); INSERT INTO `city` VALUES ('380' '30' '西双版纳' '2'); INSERT INTO `city` VALUES ('381' '30' '玉溪' '2'); INSERT INTO `city` VALUES ('382' '30' '昭通' '2'); INSERT INTO `city` VALUES ('383' '31' '杭州' '2'); INSERT INTO `city` VALUES ('384' '31' '湖州' '2'); INSERT INTO `city` VALUES ('385' '31' '嘉兴' '2'); INSERT INTO `city` VALUES ('386' '31' '金华' '2'); INSERT INTO `city` VALUES ('387' '31' '丽水' '2'); INSERT INTO `city` VALUES ('388' '31' '宁波' '2'); INSERT INTO `city` VALUES ('389' '31' '绍兴' '2'); INSERT INTO `city` VALUES ('390' '31' '台州' '2'); INSERT INTO `city` VALUES ('391' '31' '温州' '2'); INSERT INTO `city` VALUES ('392' '31' '舟山' '2');

INSERT INTO `city` VALUES ('394' '32' '重庆' '2'); INSERT INTO `city` VALUES ('395' '33' '香港' '2'); INSERT INTO `city` VALUES ('396' '34' '澳门' '2'); INSERT INTO `city` VALUES ('397' '35' '台湾' '2'); INSERT INTO `city` VALUES ('398' '36' '迎江区' '3'); INSERT INTO `city` VALUES ('399' '36' '大观区' '3'); INSERT INTO `city` VALUES ('400' '36' '宜秀区' '3'); INSERT INTO `city` VALUES ('401' '36' '桐城市' '3'); INSERT INTO `city` VALUES ('402' '36' '怀宁县' '3'); INSERT INTO `city` VALUES ('403' '36' '枞阳县' '3'); INSERT INTO `city` VALUES ('404' '36' '潜山县' '3'); INSERT INTO `city` VALUES ('405' '36' '太湖县' '3'); INSERT INTO `city` VALUES ('406' '36' '宿松县' '3'); INSERT INTO `city` VALUES ('407' '36' '望江县' '3'); INSERT INTO `city` VALUES ('408' '36' '岳西县' '3'); INSERT INTO `city` VALUES ('409' '37' '中市区' '3'); INSERT INTO `city` VALUES ('410' '37' '东市区' '3'); INSERT INTO `city` VALUES ('411' '37' '西市区' '3'); INSERT INTO `city` VALUES ('412' '37' '郊区' '3'); INSERT INTO `city` VALUES ('413' '37' '怀远县' '3'); INSERT INTO `city` VALUES ('414' '37' '五河县' '3'); INSERT INTO `city` VALUES ('415' '37' '固镇县' '3'); INSERT INTO `city` VALUES ('416' '38' '居巢区' '3'); INSERT INTO `city` VALUES ('417' '38' '庐江县' '3'); INSERT INTO `city` VALUES ('418' '38' '无为县' '3'); INSERT INTO `city` VALUES ('419' '38' '含山县' '3'); INSERT INTO `city` VALUES ('420' '38' '和县' '3'); INSERT INTO `city` VALUES ('421' '39' '贵池区' '3'); INSERT INTO `city` VALUES ('422' '39' '东至县' '3'); INSERT INTO `city` VALUES ('423' '39' '石台县' '3'); INSERT INTO `city` VALUES ('424' '39' '青阳县' '3'); INSERT INTO `city` VALUES ('425' '40' '琅琊区' '3'); INSERT INTO `city` VALUES ('426' '40' '南谯区' '3'); INSERT INTO `city` VALUES ('427' '40' '天长市' '3'); INSERT INTO `city` VALUES ('428' '40' '明光市' '3'); INSERT INTO `city` VALUES ('429' '40' '来安县' '3'); INSERT INTO `city` VALUES ('430' '40' '全椒县' '3'); INSERT INTO `city` VALUES ('431' '40' '定远县' '3'); INSERT INTO `city` VALUES ('432' '40' '凤阳县' '3');

INSERT INTO `city` VALUES ('434' '41' '龙子湖区' '3'); INSERT INTO `city` VALUES ('435' '41' '禹会区' '3'); INSERT INTO `city` VALUES ('436' '41' '淮上区' '3'); INSERT INTO `city` VALUES ('437' '41' '颍州区' '3'); INSERT INTO `city` VALUES ('438' '41' '颍东区' '3'); INSERT INTO `city` VALUES ('439' '41' '颍泉区' '3'); INSERT INTO `city` VALUES ('440' '41' '界首市' '3'); INSERT INTO `city` VALUES ('441' '41' '临泉县' '3'); INSERT INTO `city` VALUES ('442' '41' '太和县' '3'); INSERT INTO `city` VALUES ('443' '41' '阜南县' '3'); INSERT INTO `city` VALUES ('444' '41' '颖上县' '3'); INSERT INTO `city` VALUES ('445' '42' '相山区' '3'); INSERT INTO `city` VALUES ('446' '42' '杜集区' '3'); INSERT INTO `city` VALUES ('447' '42' '烈山区' '3'); INSERT INTO `city` VALUES ('448' '42' '濉溪县' '3'); INSERT INTO `city` VALUES ('449' '43' '田家庵区' '3'); INSERT INTO `city` VALUES ('450' '43' '大通区' '3'); INSERT INTO `city` VALUES ('451' '43' '谢家集区' '3'); INSERT INTO `city` VALUES ('452' '43' '八公山区' '3'); INSERT INTO `city` VALUES ('453' '43' '潘集区' '3'); INSERT INTO `city` VALUES ('454' '43' '凤台县' '3'); INSERT INTO `city` VALUES ('455' '44' '屯溪区' '3'); INSERT INTO `city` VALUES ('456' '44' '黄山区' '3'); INSERT INTO `city` VALUES ('457' '44' '徽州区' '3'); INSERT INTO `city` VALUES ('458' '44' '歙县' '3'); INSERT INTO `city` VALUES ('459' '44' '休宁县' '3'); INSERT INTO `city` VALUES ('460' '44' '黟县' '3'); INSERT INTO `city` VALUES ('461' '44' '祁门县' '3'); INSERT INTO `city` VALUES ('462' '45' '金安区' '3'); INSERT INTO `city` VALUES ('463' '45' '裕安区' '3'); INSERT INTO `city` VALUES ('464' '45' '寿县' '3'); INSERT INTO `city` VALUES ('465' '45' '霍邱县' '3'); INSERT INTO `city` VALUES ('466' '45' '舒城县' '3'); INSERT INTO `city` VALUES ('467' '45' '金寨县' '3'); INSERT INTO `city` VALUES ('468' '45' '霍山县' '3'); INSERT INTO `city` VALUES ('469' '46' '雨山区' '3'); INSERT INTO `city` VALUES ('470' '46' '花山区' '3'); INSERT INTO `city` VALUES ('471' '46' '金家庄区' '3'); INSERT INTO `city` VALUES ('472' '46' '当涂县' '3');

INSERT INTO `city` VALUES ('474' '47' '砀山县' '3'); INSERT INTO `city` VALUES ('475' '47' '萧县' '3'); INSERT INTO `city` VALUES ('476' '47' '灵璧县' '3'); INSERT INTO `city` VALUES ('477' '47' '泗县' '3'); INSERT INTO `city` VALUES ('478' '48' '铜官山区' '3'); INSERT INTO `city` VALUES ('479' '48' '狮子山区' '3'); INSERT INTO `city` VALUES ('480' '48' '郊区' '3'); INSERT INTO `city` VALUES ('481' '48' '铜陵县' '3'); INSERT INTO `city` VALUES ('482' '49' '镜湖区' '3'); INSERT INTO `city` VALUES ('483' '49' '弋江区' '3'); INSERT INTO `city` VALUES ('484' '49' '鸠江区' '3'); INSERT INTO `city` VALUES ('485' '49' '三山区' '3'); INSERT INTO `city` VALUES ('486' '49' '芜湖县' '3'); INSERT INTO `city` VALUES ('487' '49' '繁昌县' '3'); INSERT INTO `city` VALUES ('488' '49' '南陵县' '3'); INSERT INTO `city` VALUES ('489' '50' '宣州区' '3'); INSERT INTO `city` VALUES ('490' '50' '宁国市' '3'); INSERT INTO `city` VALUES ('491' '50' '郎溪县' '3'); INSERT INTO `city` VALUES ('492' '50' '广德县' '3'); INSERT INTO `city` VALUES ('493' '50' '泾县' '3'); INSERT INTO `city` VALUES ('494' '50' '绩溪县' '3'); INSERT INTO `city` VALUES ('495' '50' '旌德县' '3'); INSERT INTO `city` VALUES ('496' '51' '涡阳县' '3'); INSERT INTO `city` VALUES ('497' '51' '蒙城县' '3'); INSERT INTO `city` VALUES ('498' '51' '利辛县' '3'); INSERT INTO `city` VALUES ('499' '51' '谯城区' '3'); INSERT INTO `city` VALUES ('500' '52' '东城区' '3'); INSERT INTO `city` VALUES ('501' '52' '西城区' '3'); INSERT INTO `city` VALUES ('502' '52' '海淀区' '3'); INSERT INTO `city` VALUES ('503' '52' '朝阳区' '3'); INSERT INTO `city` VALUES ('504' '52' '崇文区' '3'); INSERT INTO `city` VALUES ('505' '52' '宣武区' '3'); INSERT INTO `city` VALUES ('506' '52' '丰台区' '3'); INSERT INTO `city` VALUES ('507' '52' '石景山区' '3'); INSERT INTO `city` VALUES ('508' '52' '房山区' '3'); INSERT INTO `city` VALUES ('509' '52' '门头沟区' '3'); INSERT INTO `city` VALUES ('510' '52' '通州区' '3'); INSERT INTO `city` VALUES ('511' '52' '顺义区' '3'); INSERT INTO `city` VALUES ('512' '52' '昌平区' '3');

INSERT INTO `city` VALUES ('514' '52' '平谷区' '3'); INSERT INTO `city` VALUES ('515' '52' '大兴区' '3'); INSERT INTO `city` VALUES ('516' '52' '密云县' '3'); INSERT INTO `city` VALUES ('517' '52' '延庆县' '3'); INSERT INTO `city` VALUES ('518' '53' '鼓楼区' '3'); INSERT INTO `city` VALUES ('519' '53' '台江区' '3'); INSERT INTO `city` VALUES ('520' '53' '仓山区' '3'); INSERT INTO `city` VALUES ('521' '53' '马尾区' '3'); INSERT INTO `city` VALUES ('522' '53' '晋安区' '3'); INSERT INTO `city` VALUES ('523' '53' '福清市' '3'); INSERT INTO `city` VALUES ('524' '53' '长乐市' '3'); INSERT INTO `city` VALUES ('525' '53' '闽侯县' '3'); INSERT INTO `city` VALUES ('526' '53' '连江县' '3'); INSERT INTO `city` VALUES ('527' '53' '罗源县' '3'); INSERT INTO `city` VALUES ('528' '53' '闽清县' '3'); INSERT INTO `city` VALUES ('529' '53' '永泰县' '3'); INSERT INTO `city` VALUES ('530' '53' '平潭县' '3'); INSERT INTO `city` VALUES ('531' '54' '新罗区' '3'); INSERT INTO `city` VALUES ('532' '54' '漳平市' '3'); INSERT INTO `city` VALUES ('533' '54' '长汀县' '3'); INSERT INTO `city` VALUES ('534' '54' '永定县' '3'); INSERT INTO `city` VALUES ('535' '54' '上杭县' '3'); INSERT INTO `city` VALUES ('536' '54' '武平县' '3'); INSERT INTO `city` VALUES ('537' '54' '连城县' '3'); INSERT INTO `city` VALUES ('538' '55' '延平区' '3'); INSERT INTO `city` VALUES ('539' '55' '邵武市' '3'); INSERT INTO `city` VALUES ('540' '55' '武夷山市' '3'); INSERT INTO `city` VALUES ('541' '55' '建瓯市' '3'); INSERT INTO `city` VALUES ('542' '55' '建阳市' '3'); INSERT INTO `city` VALUES ('543' '55' '顺昌县' '3'); INSERT INTO `city` VALUES ('544' '55' '浦城县' '3'); INSERT INTO `city` VALUES ('545' '55' '光泽县' '3'); INSERT INTO `city` VALUES ('546' '55' '松溪县' '3'); INSERT INTO `city` VALUES ('547' '55' '政和县' '3'); INSERT INTO `city` VALUES ('548' '56' '蕉城区' '3'); INSERT INTO `city` VALUES ('549' '56' '福安市' '3'); INSERT INTO `city` VALUES ('550' '56' '福鼎市' '3'); INSERT INTO `city` VALUES ('551' '56' '霞浦县' '3'); INSERT INTO `city` VALUES ('552' '56' '古田县' '3');

INSERT INTO `city` VALUES ('554' '56' '寿宁县' '3'); INSERT INTO `city` VALUES ('555' '56' '周宁县' '3'); INSERT INTO `city` VALUES ('556' '56' '柘荣县' '3'); INSERT INTO `city` VALUES ('557' '57' '城厢区' '3'); INSERT INTO `city` VALUES ('558' '57' '涵江区' '3'); INSERT INTO `city` VALUES ('559' '57' '荔城区' '3'); INSERT INTO `city` VALUES ('560' '57' '秀屿区' '3'); INSERT INTO `city` VALUES ('561' '57' '仙游县' '3'); INSERT INTO `city` VALUES ('562' '58' '鲤城区' '3'); INSERT INTO `city` VALUES ('563' '58' '丰泽区' '3'); INSERT INTO `city` VALUES ('564' '58' '洛江区' '3'); INSERT INTO `city` VALUES ('565' '58' '清濛开发区' '3'); INSERT INTO `city` VALUES ('566' '58' '泉港区' '3'); INSERT INTO `city` VALUES ('567' '58' '石狮市' '3'); INSERT INTO `city` VALUES ('568' '58' '晋江市' '3'); INSERT INTO `city` VALUES ('569' '58' '南安市' '3'); INSERT INTO `city` VALUES ('570' '58' '惠安县' '3'); INSERT INTO `city` VALUES ('571' '58' '安溪县' '3'); INSERT INTO `city` VALUES ('572' '58' '永春县' '3'); INSERT INTO `city` VALUES ('573' '58' '德化县' '3'); INSERT INTO `city` VALUES ('574' '58' '金门县' '3'); INSERT INTO `city` VALUES ('575' '59' '梅列区' '3'); INSERT INTO `city` VALUES ('576' '59' '三元区' '3'); INSERT INTO `city` VALUES ('577' '59' '永安市' '3'); INSERT INTO `city` VALUES ('578' '59' '明溪县' '3'); INSERT INTO `city` VALUES ('579' '59' '清流县' '3'); INSERT INTO `city` VALUES ('580' '59' '宁化县' '3'); INSERT INTO `city` VALUES ('581' '59' '大田县' '3'); INSERT INTO `city` VALUES ('582' '59' '尤溪县' '3'); INSERT INTO `city` VALUES ('583' '59' '沙县' '3'); INSERT INTO `city` VALUES ('584' '59' '将乐县' '3'); INSERT INTO `city` VALUES ('585' '59' '泰宁县' '3'); INSERT INTO `city` VALUES ('586' '59' '建宁县' '3'); INSERT INTO `city` VALUES ('587' '60' '思明区' '3'); INSERT INTO `city` VALUES ('588' '60' '海沧区' '3'); INSERT INTO `city` VALUES ('589' '60' '湖里区' '3'); INSERT INTO `city` VALUES ('590' '60' '集美区' '3'); INSERT INTO `city` VALUES ('591' '60' '同安区' '3'); INSERT INTO `city` VALUES ('592' '60' '翔安区' '3');

INSERT INTO `city` VALUES ('594' '61' '龙文区' '3'); INSERT INTO `city` VALUES ('595' '61' '龙海市' '3'); INSERT INTO `city` VALUES ('596' '61' '云霄县' '3'); INSERT INTO `city` VALUES ('597' '61' '漳浦县' '3'); INSERT INTO `city` VALUES ('598' '61' '诏安县' '3'); INSERT INTO `city` VALUES ('599' '61' '长泰县' '3'); INSERT INTO `city` VALUES ('600' '61' '东山县' '3'); INSERT INTO `city` VALUES ('601' '61' '南靖县' '3'); INSERT INTO `city` VALUES ('602' '61' '平和县' '3'); INSERT INTO `city` VALUES ('603' '61' '华安县' '3'); INSERT INTO `city` VALUES ('604' '62' '皋兰县' '3'); INSERT INTO `city` VALUES ('605' '62' '城关区' '3'); INSERT INTO `city` VALUES ('606' '62' '七里河区' '3'); INSERT INTO `city` VALUES ('607' '62' '西固区' '3'); INSERT INTO `city` VALUES ('608' '62' '安宁区' '3'); INSERT INTO `city` VALUES ('609' '62' '红古区' '3'); INSERT INTO `city` VALUES ('610' '62' '永登县' '3'); INSERT INTO `city` VALUES ('611' '62' '榆中县' '3'); INSERT INTO `city` VALUES ('612' '63' '白银区' '3'); INSERT INTO `city` VALUES ('613' '63' '平川区' '3'); INSERT INTO `city` VALUES ('614' '63' '会宁县' '3'); INSERT INTO `city` VALUES ('615' '63' '景泰县' '3'); INSERT INTO `city` VALUES ('616' '63' '靖远县' '3'); INSERT INTO `city` VALUES ('617' '64' '临洮县' '3'); INSERT INTO `city` VALUES ('618' '64' '陇西县' '3'); INSERT INTO `city` VALUES ('619' '64' '通渭县' '3'); INSERT INTO `city` VALUES ('620' '64' '渭源县' '3'); INSERT INTO `city` VALUES ('621' '64' '漳县' '3'); INSERT INTO `city` VALUES ('622' '64' '岷县' '3'); INSERT INTO `city` VALUES ('623' '64' '安定区' '3'); INSERT INTO `city` VALUES ('624' '64' '安定区' '3'); INSERT INTO `city` VALUES ('625' '65' '合作市' '3'); INSERT INTO `city` VALUES ('626' '65' '临潭县' '3'); INSERT INTO `city` VALUES ('627' '65' '卓尼县' '3'); INSERT INTO `city` VALUES ('628' '65' '舟曲县' '3'); INSERT INTO `city` VALUES ('629' '65' '迭部县' '3'); INSERT INTO `city` VALUES ('630' '65' '玛曲县' '3'); INSERT INTO `city` VALUES ('631' '65' '碌曲县' '3'); INSERT INTO `city` VALUES ('632' '65' '夏河县' '3');

INSERT INTO `city` VALUES ('634' '67' '金川区' '3'); INSERT INTO `city` VALUES ('635' '67' '永昌县' '3'); INSERT INTO `city` VALUES ('636' '68' '肃州区' '3'); INSERT INTO `city` VALUES ('637' '68' '玉门市' '3'); INSERT INTO `city` VALUES ('638' '68' '敦煌市' '3'); INSERT INTO `city` VALUES ('639' '68' '金塔县' '3'); INSERT INTO `city` VALUES ('640' '68' '瓜州县' '3'); INSERT INTO `city` VALUES ('641' '68' '肃北' '3'); INSERT INTO `city` VALUES ('642' '68' '阿克塞' '3'); INSERT INTO `city` VALUES ('643' '69' '临夏市' '3'); INSERT INTO `city` VALUES ('644' '69' '临夏县' '3'); INSERT INTO `city` VALUES ('645' '69' '康乐县' '3'); INSERT INTO `city` VALUES ('646' '69' '永靖县' '3'); INSERT INTO `city` VALUES ('647' '69' '广河县' '3'); INSERT INTO `city` VALUES ('648' '69' '和政县' '3'); INSERT INTO `city` VALUES ('649' '69' '东乡族自治县' '3'); INSERT INTO `city` VALUES ('650' '69' '积石山' '3'); INSERT INTO `city` VALUES ('651' '70' '成县' '3'); INSERT INTO `city` VALUES ('652' '70' '徽县' '3'); INSERT INTO `city` VALUES ('653' '70' '康县' '3'); INSERT INTO `city` VALUES ('654' '70' '礼县' '3'); INSERT INTO `city` VALUES ('655' '70' '两当县' '3'); INSERT INTO `city` VALUES ('656' '70' '文县' '3'); INSERT INTO `city` VALUES ('657' '70' '西和县' '3'); INSERT INTO `city` VALUES ('658' '70' '宕昌县' '3'); INSERT INTO `city` VALUES ('659' '70' '武都区' '3'); INSERT INTO `city` VALUES ('660' '71' '崇信县' '3'); INSERT INTO `city` VALUES ('661' '71' '华亭县' '3'); INSERT INTO `city` VALUES ('662' '71' '静宁县' '3'); INSERT INTO `city` VALUES ('663' '71' '灵台县' '3'); INSERT INTO `city` VALUES ('664' '71' '崆峒区' '3'); INSERT INTO `city` VALUES ('665' '71' '庄浪县' '3'); INSERT INTO `city` VALUES ('666' '71' '泾川县' '3'); INSERT INTO `city` VALUES ('667' '72' '合水县' '3'); INSERT INTO `city` VALUES ('668' '72' '华池县' '3'); INSERT INTO `city` VALUES ('669' '72' '环县' '3'); INSERT INTO `city` VALUES ('670' '72' '宁县' '3'); INSERT INTO `city` VALUES ('671' '72' '庆城县' '3'); INSERT INTO `city` VALUES ('672' '72' '西峰区' '3');

INSERT INTO `city` VALUES ('674' '72' '正宁县' '3'); INSERT INTO `city` VALUES ('675' '73' '甘谷县' '3'); INSERT INTO `city` VALUES ('676' '73' '秦安县' '3'); INSERT INTO `city` VALUES ('677' '73' '清水县' '3'); INSERT INTO `city` VALUES ('678' '73' '秦州区' '3'); INSERT INTO `city` VALUES ('679' '73' '麦积区' '3'); INSERT INTO `city` VALUES ('680' '73' '武山县' '3'); INSERT INTO `city` VALUES ('681' '73' '张家川' '3'); INSERT INTO `city` VALUES ('682' '74' '古浪县' '3'); INSERT INTO `city` VALUES ('683' '74' '民勤县' '3'); INSERT INTO `city` VALUES ('684' '74' '天祝' '3'); INSERT INTO `city` VALUES ('685' '74' '凉州区' '3'); INSERT INTO `city` VALUES ('686' '75' '高台县' '3'); INSERT INTO `city` VALUES ('687' '75' '临泽县' '3'); INSERT INTO `city` VALUES ('688' '75' '民乐县' '3'); INSERT INTO `city` VALUES ('689' '75' '山丹县' '3'); INSERT INTO `city` VALUES ('690' '75' '肃南' '3'); INSERT INTO `city` VALUES ('691' '75' '甘州区' '3'); INSERT INTO `city` VALUES ('692' '76' '从化市' '3'); INSERT INTO `city` VALUES ('693' '76' '天河区' '3'); INSERT INTO `city` VALUES ('694' '76' '东山区' '3'); INSERT INTO `city` VALUES ('695' '76' '白云区' '3'); INSERT INTO `city` VALUES ('696' '76' '海珠区' '3'); INSERT INTO `city` VALUES ('697' '76' '荔湾区' '3'); INSERT INTO `city` VALUES ('698' '76' '越秀区' '3'); INSERT INTO `city` VALUES ('699' '76' '黄埔区' '3'); INSERT INTO `city` VALUES ('700' '76' '番禺区' '3'); INSERT INTO `city` VALUES ('701' '76' '花都区' '3'); INSERT INTO `city` VALUES ('702' '76' '增城区' '3'); INSERT INTO `city` VALUES ('703' '76' '从化区' '3'); INSERT INTO `city` VALUES ('704' '76' '市郊' '3'); INSERT INTO `city` VALUES ('705' '77' '福田区' '3'); INSERT INTO `city` VALUES ('706' '77' '罗湖区' '3'); INSERT INTO `city` VALUES ('707' '77' '南山区' '3'); INSERT INTO `city` VALUES ('708' '77' '宝安区' '3'); INSERT INTO `city` VALUES ('709' '77' '龙岗区' '3'); INSERT INTO `city` VALUES ('710' '77' '盐田区' '3'); INSERT INTO `city` VALUES ('711' '78' '湘桥区' '3'); INSERT INTO `city` VALUES ('712' '78' '潮安县' '3');

INSERT INTO `city` VALUES ('714' '79' '南城区' '3'); INSERT INTO `city` VALUES ('715' '79' '东城区' '3'); INSERT INTO `city` VALUES ('716' '79' '万江区' '3'); INSERT INTO `city` VALUES ('717' '79' '莞城区' '3'); INSERT INTO `city` VALUES ('718' '79' '石龙镇' '3'); INSERT INTO `city` VALUES ('719' '79' '虎门镇' '3'); INSERT INTO `city` VALUES ('720' '79' '麻涌镇' '3'); INSERT INTO `city` VALUES ('721' '79' '道滘镇' '3'); INSERT INTO `city` VALUES ('722' '79' '石碣镇' '3'); INSERT INTO `city` VALUES ('723' '79' '沙田镇' '3'); INSERT INTO `city` VALUES ('724' '79' '望牛墩镇' '3'); INSERT INTO `city` VALUES ('725' '79' '洪梅镇' '3'); INSERT INTO `city` VALUES ('726' '79' '茶山镇' '3'); INSERT INTO `city` VALUES ('727' '79' '寮步镇' '3'); INSERT INTO `city` VALUES ('728' '79' '大岭山镇' '3'); INSERT INTO `city` VALUES ('729' '79' '大朗镇' '3'); INSERT INTO `city` VALUES ('730' '79' '黄江镇' '3'); INSERT INTO `city` VALUES ('731' '79' '樟木头' '3'); INSERT INTO `city` VALUES ('732' '79' '凤岗镇' '3'); INSERT INTO `city` VALUES ('733' '79' '塘厦镇' '3'); INSERT INTO `city` VALUES ('734' '79' '谢岗镇' '3'); INSERT INTO `city` VALUES ('735' '79' '厚街镇' '3'); INSERT INTO `city` VALUES ('736' '79' '清溪镇' '3'); INSERT INTO `city` VALUES ('737' '79' '常平镇' '3'); INSERT INTO `city` VALUES ('738' '79' '桥头镇' '3'); INSERT INTO `city` VALUES ('739' '79' '横沥镇' '3'); INSERT INTO `city` VALUES ('740' '79' '东坑镇' '3'); INSERT INTO `city` VALUES ('741' '79' '企石镇' '3'); INSERT INTO `city` VALUES ('742' '79' '石排镇' '3'); INSERT INTO `city` VALUES ('743' '79' '长安镇' '3'); INSERT INTO `city` VALUES ('744' '79' '中堂镇' '3'); INSERT INTO `city` VALUES ('745' '79' '高埗镇' '3'); INSERT INTO `city` VALUES ('746' '80' '禅城区' '3'); INSERT INTO `city` VALUES ('747' '80' '南海区' '3'); INSERT INTO `city` VALUES ('748' '80' '顺德区' '3'); INSERT INTO `city` VALUES ('749' '80' '三水区' '3'); INSERT INTO `city` VALUES ('750' '80' '高明区' '3'); INSERT INTO `city` VALUES ('751' '81' '东源县' '3'); INSERT INTO `city` VALUES ('752' '81' '和平县' '3');

INSERT INTO `city` VALUES ('754' '81' '连平县' '3'); INSERT INTO `city` VALUES ('755' '81' '龙川县' '3'); INSERT INTO `city` VALUES ('756' '81' '紫金县' '3'); INSERT INTO `city` VALUES ('757' '82' '惠阳区' '3'); INSERT INTO `city` VALUES ('758' '82' '惠城区' '3'); INSERT INTO `city` VALUES ('759' '82' '大亚湾' '3'); INSERT INTO `city` VALUES ('760' '82' '博罗县' '3'); INSERT INTO `city` VALUES ('761' '82' '惠东县' '3'); INSERT INTO `city` VALUES ('762' '82' '龙门县' '3'); INSERT INTO `city` VALUES ('763' '83' '江海区' '3'); INSERT INTO `city` VALUES ('764' '83' '蓬江区' '3'); INSERT INTO `city` VALUES ('765' '83' '新会区' '3'); INSERT INTO `city` VALUES ('766' '83' '台山市' '3'); INSERT INTO `city` VALUES ('767' '83' '开平市' '3'); INSERT INTO `city` VALUES ('768' '83' '鹤山市' '3'); INSERT INTO `city` VALUES ('769' '83' '恩平市' '3'); INSERT INTO `city` VALUES ('770' '84' '榕城区' '3'); INSERT INTO `city` VALUES ('771' '84' '普宁市' '3'); INSERT INTO `city` VALUES ('772' '84' '揭东县' '3'); INSERT INTO `city` VALUES ('773' '84' '揭西县' '3'); INSERT INTO `city` VALUES ('774' '84' '惠来县' '3'); INSERT INTO `city` VALUES ('775' '85' '茂南区' '3'); INSERT INTO `city` VALUES ('776' '85' '茂港区' '3'); INSERT INTO `city` VALUES ('777' '85' '高州市' '3'); INSERT INTO `city` VALUES ('778' '85' '化州市' '3'); INSERT INTO `city` VALUES ('779' '85' '信宜市' '3'); INSERT INTO `city` VALUES ('780' '85' '电白县' '3'); INSERT INTO `city` VALUES ('781' '86' '梅县' '3'); INSERT INTO `city` VALUES ('782' '86' '梅江区' '3'); INSERT INTO `city` VALUES ('783' '86' '兴宁市' '3'); INSERT INTO `city` VALUES ('784' '86' '大埔县' '3'); INSERT INTO `city` VALUES ('785' '86' '丰顺县' '3'); INSERT INTO `city` VALUES ('786' '86' '五华县' '3'); INSERT INTO `city` VALUES ('787' '86' '平远县' '3'); INSERT INTO `city` VALUES ('788' '86' '蕉岭县' '3'); INSERT INTO `city` VALUES ('789' '87' '清城区' '3'); INSERT INTO `city` VALUES ('790' '87' '英德市' '3'); INSERT INTO `city` VALUES ('791' '87' '连州市' '3'); INSERT INTO `city` VALUES ('792' '87' '佛冈县' '3');

全国省市县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查询语句大全

经典SQL查询语句大全一、基础 1、说明：创建数据库 CREATE DATABASE database-name 2、说明：删除数据库 drop database dbname 3、说明：备份sql server --- 创建备份数据的 device USE master EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1. dat' --- 开始备份 BACKUP DATABASE pubs TO testBack 4、说明：创建新表 create table tabname(col1 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、说明：删除新表 drop table tabname 6、说明：增加一个列 Alter table tabname add column col type 注：列增加后将不能删除。DB2中列加上后数据类型也不能改变，唯一能改变的是增加varchar类型的长度。 7、说明：添加主键：Alter table tabname add primary key(col) 说明：删除主键： Alter table tabname drop primary key(col) 8、说明：创建索引：create [unique] index idxname on tab name(col….) 删除索引：drop index idxname 注：索引是不可更改的，想更改必须删除重新建。 9、说明：创建视图：create view viewname as select statement 删除视图：drop view viewname 10、说明：几个简单的基本的sql语句选择：select * from table1 where 范围插入：insert into table1(field1,field2) values(value1,value2) 删除：delete from table1 where 范围更新：update table1 set field1=value1 where 范围查找：select * from table1 where field1 like ’%value1%’ ---like的语法很精妙，查资料!

计算机三级数据库SQL语句大全

1、说明：创建数据库 CREATE DATABASE database-name 2、说明：删除数据库 drop database dbname 3、说明：备份sql server --- 创建备份数据的device USE master EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat' --- 开始备份 BACKUP DATABASE pubs TO testBack 4、说明：创建新表 create table tabname(col1 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、说明：删除新表 drop table tabname 6、说明：增加一个列 Alter table tabname add column col type 注：列增加后将不能删除。DB2中列加上后数据类型也不能改变，唯一能改变的是增加varchar类型的长度。 7、说明：添加主键：Alter table tabname add primary key(col) 说明：删除主键：Alter table tabname drop primary key(col) 8、说明：创建索引：create [uniqu e] index idxname on tabname(col….) 删除索引：drop index idxname 注：索引是不可更改的，想更改必须删除重新建。 9、说明：创建视图：create view viewname as select statement 删除视图：drop view viewname 10、说明：几个简单的基本的sql语句选择：select * from table1 where 范围插入：insert into table1(field1,field2) values(value1,value2) 删除：delete from table1 where 范围更新：update table1 set field1=value1 where 范围查找：select * from table1 where field1 like ?%value1%? ---like的语法很精妙，查资料! 排序：select * from table1 order by field1,field2 [desc] 总数：select count as totalcount from table1 求和：select sum(field1) as sumvalue from table1 平均：select avg(field1) as avgvalue from table1 最大：select max(field1) as maxvalue from table1 最小：select min(field1) as minvalue from table1 11、说明：几个高级查询运算词 A：UNION 运算符 UNION 运算符通过组合其他两个结果表(例如TABLE1 和TABLE2)并消去表中任何重复行而派生出一个结果表。当ALL 随UNION 一起使用时(即UNION ALL)，不消除重复行。两种情况下，派生表的每一行不是来自TABLE1 就是来自TABLE2。 B：EXCEPT 运算符 EXCEPT 运算符通过包括所有在TABLE1 中但不在TABLE2 中的行并消除所有重复行而派生出一个结果表。当ALL 随EXCEPT 一起使用时(EXCEPT ALL)，不消除重复行。 C：INTERSECT 运算符

中国省市区三级数据库表.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');

全国省市区县大全

中国省市县名称大全直辖市（北京、上海、天津、重庆）北京：东城区、西城区、崇文区、宣武区、朝阳区、丰台区、石景山区、海淀区、门头沟区、房山区、通州区、顺义区、昌平区、大兴区、怀柔区、平谷区、密云县、延庆县上海：黄浦区、卢湾区、徐汇区、徐家汇、长宁区、静安区、普陀区、闸北区虹口区、杨浦区、宝山区、闵行区、嘉定区、浦东新区、松江区、金山区、青浦区、南汇区、奉贤区、崇明县天津：和平区、河东区、河西区、南开区、河北区、红桥区、塘沽区、汉沽区、大港区、东丽区、西青区、北辰区、津南区、武清区、宝坻区、静海县、宁河县重庆：渝中区、大渡口区、江北区、沙坪坝区、九龙坡区、南岸区、北碚区、万盛区、双桥区、渝北区、巴南区、万州区、涪陵区、黔江区、长寿区、永川市、合川市、江津市、南川市、綦江县、潼南县、荣昌县、璧山县、大足县、铜梁县、梁平县、城口县、垫江县、武隆县、丰都县、奉节县、开县、云阳县、忠县、巫溪县、巫山县、石柱县、秀山县、酉阳县、彭水县

华北地区（河北、山西、内蒙古）河北：石家庄市：长安区、桥西区、井陉矿区、井陉县、栾城县、灵寿县、深泽县、无极县、元氏县、辛集市、晋州市、鹿泉市、桥东区、新华区、裕华区、正定县、行唐县、高邑县、赞皇县、平山县、赵县、藁城市、新乐市唐山市：路南区、古冶区、丰南区、滦县、乐亭县、玉田县、遵化市、路北区、开平区、丰润区、滦南县、迁西县、唐海县、迁安市秦皇岛市：海港区、北戴河区、昌黎县、卢龙县、山海关区、青龙满族自治县、抚宁县邯郸市：邯山区、复兴区、邯郸县、成安县、涉县、肥乡县、邱县、广平县、魏县、武安市、丛台区、峰峰矿区、临漳县、大名县、磁县、永年县、鸡泽县、馆陶县、曲周县邢台市：桥东区、邢台县、内丘县、隆尧县、南和县、巨鹿县、广宗县、威县、临西县、沙河市、桥西区、临城县、柏乡县、任县、宁晋县、新河县、平乡县、清河县、南宫市保定市：新市区、南市区、清苑县、阜平县、定兴县、高阳县、涞源县、安新县、曲阳县、顺平县、雄县、定州市、高碑店市、北市区、满城县、涞水县、徐水县、唐县、容城县、望都县、易县、蠡县、博野县、涿州市、安国市张家口市：桥东区、宣化区、宣化县、康保县、尚义县、阳原县、万全县、涿鹿县、崇礼县、桥西区、下花园区、张北县、沽源县、蔚县、

Microsoft Access数据库中SQL语句大全

引子：如何找到ACCESS数据库的SQL视图： 1）单击下图左侧的： 2）单击上图顶部的，弹出如下图对话框： 5）单击“关闭”，此时在菜单中的文件菜单下面出现一个SQL的下拉框；6）在“SQL”下拉框中选择如下图所示中的“SQL视图即可”。 1、查询所有记录：Select *通常用于快速查看表中的记录。当对表的结构无法确切记忆时，或要快速查看表中的记录时，使用Select *是很方便的。 use 企业销售管理系统 Select * from 职工 2、投影查询：很多时候并不需要将所有列的数据都显示出来。投影查询就是允许用户显示所需要的列。假设显示职工表中职工号、姓名、工资信息，具体操作方法如下。 Select 职工号,姓名,工资 from 职工在Select查询中，还可以按照实际的需要或自己的喜好安排显示列的顺序，如果要把姓名放到第一列，则代码如下： Select姓名, 职工号,工资 from 职工 3、条件查询：显示wh1或wh2仓库、性别不为女、工资在1300～2100之间的职工信息。具体操作如下： Select * from职工号 where(仓库号=’wh1’ or仓库号=’wh2’) And not 性别=’女’ and 工资>=1300 and 工资工资<=2100 在这里一定要注意，(仓库号=’wh1’ or仓库号=’wh2’)一定要加括号，否则就不是原题的意思。 4、谓词In查询：在查找特定条件的数据时，如果条件较多，就需要用到多个O r运算符，以查找满足其中任一条的记录。但使用多个Or运算符，将使Where

在SQL语句中，还支持Like与Not结合使用。假设显示姓名中不含有“王”字的职工信息，具体代码如下： Select * from职工 where 姓名not like’王%’

sql数据库查询语句

SQL查询语句大全 SQL语句无论是种类还是数量都是繁多的，很多语句也是经常要用到的，SQL查询语句就是一个典型的例子，无论是高级查询还是低级查询，SQL查询语句的需求是最频繁的。那么SQL查询语句有哪些？一、简单查询语句 1. 查看表结构 SQL>DESC emp; 2. 查询所有列 SQL>SELECT * FROM emp; 3. 查询指定列 SQL>SELECT empmo, ename, mgr FROM emp; SQL>SELECT DISTINCT mgr FROM emp; 只显示结果不同的项 4. 查询指定行 SQL>SELECT * FROM emp WHERE job='CLERK'; 5. 使用算术表达式 SQL>SELECT ename, sal*13+nvl(comm,0) FROM emp;

nvl(comm,1)的意思是，如果comm中有值，则nvl(comm,1)=comm; comm中无值，则nvl(comm,1)=0。 SQL>SELECT ename, sal*13+nvl(comm,0) year_sal FROM emp; （year_sal为别名，可按别名排序） SQL>SELECT * FROM emp WHERE hiredate>'01-1月-82'; 6. 使用like操作符（%，_） %表示一个或多个字符，_表示一个字符，[charlist]表示字符列中的任何单一字符，[^charlist]或者[!charlist]不在字符列中的任何单一字符。 SQL>SELECT * FROM emp WHERE ename like 'S__T%'; 7. 在where条件中使用In SQL>SELECT * FROM emp WHERE job IN ('CLERK','ANALYST'); 8. 查询字段内容为空/非空的语句 SQL>SELECT * FROM emp WHERE mgr IS/IS NOT NULL; 9. 使用逻辑操作符号 SQL>SELECT * FROM emp WHERE (sal>500 or job='MANAGE') and ename like 'J%'; 10. 将查询结果按字段的值进行排序

数据库SQL查询语句大全

一、简单查询简单的SQL查询只包括选择列表、FROM子句和WHERE子句。它们分别说明所查询列、查询的表或视图、以及搜索条件等。例如，下面的语句查询testtable表中姓名为“张三”的nickname字段和email 字段。 SELECT nickname,email FROM testtable WHERE name='张三' (一) 选择列表选择列表(select_list)指出所查询列，它可以是一组列名列表、星号、表达式、变量(包括局部变量和全局变量)等构成。 1、选择所有列例如，下面语句显示testtable表中所有列的数据： SELECT * FROM testtable 2、选择部分列并指定它们的显示次序查询结果集合中数据的排列顺序与选择列表中所指定的列名排列顺序相同。例如： SELECT nickname,email FROM testtable 3、更改列标题在选择列表中，可重新指定列标题。定义格式为：列标题=列名列名列标题如果指定的列标题不是标准的标识符格式时，应使用引号定界符，例如，下列语句使用汉字显示列标题： SELECT 昵称=nickname,电子邮件=email FROM testtable 4、删除重复行 SELECT语句中使用ALL或DISTINCT选项来显示表中符合条件的所有行或删除其中重复的数据行，默认

为ALL。使用DISTINCT选项时，对于所有重复的数据行在SELECT返回的结果集合中只保留一行。 5、限制返回的行数使用TOP n [PERCENT]选项限制返回的数据行数，TOP n说明返回n行，而TOP n PERCENT时，说明n是表示一百分数，指定返回的行数等于总行数的百分之几。例如： SELECT TOP 2 * FROM testtable SELECT TOP 20 PERCENT * FROM testtable (二) FROM子句 FROM子句指定SELECT语句查询及与查询相关的表或视图。在FROM子句中最多可指定256个表或视图，它们之间用逗号分隔。在FROM子句同时指定多个表或视图时，如果选择列表中存在同名列，这时应使用对象名限定这些列所属的表或视图。例如在usertable和citytable表中同时存在cityid列，在查询两个表中的cityid时应使用下面语句格式加以限定： SELECT username,citytable.cityid FROM usertable,citytable WHERE usertable.cityid=citytable.cityid 在FROM子句中可用以下两种格式为表或视图指定别名：表名 as 别名表名别名例如上面语句可用表的别名格式表示为： SELECT username,b.cityid FROM usertable a,citytable b WHERE a.cityid=b.cityid SELECT不仅能从表或视图中检索数据，它还能够从其它查询语句所返回的结果集合中查询数据。例如： SELECT a.au_fname a.au_lname FROM authors a,titleauthor ta (SELECT title_id,title FROM titles WHERE ytd_sales>10000 ) AS t

sql 数据库省市区数据建表和数据

-- 表的结构area DROP TABLE area; CREATE TABLE area( id int NOT NULL, areaID int NOT NULL, area varchar(200)NOT NULL, fatherID int NOT NULL, PRIMARY KEY (id) ) DROP TABLE city; CREATE TABLE city( id int NOT NULL, cityID int NOT NULL, city varchar(200)NOT NULL, fatherID int NOT NULL, PRIMARY KEY (id) ) -- -- 导出表中的数据city -- -- -------------------------------------------------------- -- -- 表的结构province -- DROP TABLE province; CREATE TABLE province( id int NOT NULL, provinceID int NOT NULL, province varchar(200)NOT NULL, PRIMARY KEY (id)) insert province(id,provinceID,province) select 1,110000,'北京市'union select 2,120000,'天津市'union select 3,130000,'河北省'union

select 4,140000,'山西省'union select 5,150000,'内蒙古自治区'union select 6,210000,'辽宁省'union select 7,220000,'吉林省'union select 8,230000,'黑龙江省'union select 9,310000,'上海市'union select 10,320000,'江苏省'union select 11,330000,'浙江省'union select 12,340000,'安徽省'union select 13,350000,'福建省'union select 14,360000,'江西省'union select 15,370000,'山东省'union select 16,410000,'河南省'union select 17,420000,'湖北省'union select 18,430000,'湖南省'union select 19,440000,'广东省'union select 20,450000,'广西壮族自治区'union select 21,460000,'海南省'union select 22,500000,'重庆市'union select 23,510000,'四川省'union select 24,520000,'贵州省'union select 25,530000,'云南省'union select 26,540000,'西藏自治区'union select 27,610000,'陕西省'union select 28,620000,'甘肃省'union select 29,630000,'青海省'union select 30,640000,'宁夏回族自治区'union select 31,650000,'新疆维吾尔自治区'union select 32,710000,'台湾省'union select 33,810000,'香港特别行政区'union select 34,820000,'澳门特别行政区' INSERT city(id,cityID,city,fatherID) select 1,110100,'市辖区',110000 union select 2,110200,'县',110000 union select 3,120100,'市辖区',120000 union select 4,120200,'县',120000 union select 5,130100,'石家庄市',130000 union select 6,130200,'唐山市',130000 union select 7,130300,'秦皇岛市',130000 union select 8,130400,'邯郸市',130000 union select 9,130500,'邢台市',130000 union select 10,130600,'保定市',130000 union

全国省市县三级联动(数据完整版)

全国省市县三级联动（数据完整版）网页前台代码： <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Defaul t" EnableEventValidation="false"%> <%@ Register assembly="AjaxControlToolkit"namespace="AjaxControlToolkit" tagprefix="cc1" %> 无标题页

全国省市县

省

数据库sql查询语句大全

数据库sql查询语句大全数据库SQL查询语句是用来从数据库中检索数据的命令。以下是一些常见的SQL查询语句大全： 1. SELECT语句，用于从数据库中选择数据。例如，SELECT FROM 表名; 2. WHERE子句，用于过滤数据，只返回满足特定条件的行。例如，SELECT FROM 表名 WHERE 列名 = '条件'; 3. ORDER BY子句，用于对结果集按照指定列进行排序。例如，SELECT FROM 表名 ORDER BY 列名; 4. GROUP BY子句，用于对结果集按照指定列进行分组。例如，SELECT 列名1, 列名2 FROM 表名 GROUP BY 列名1;

5. HAVING子句，用于过滤分组后的数据。例如，SELECT 列名1, COUNT(列名2) FROM 表名 GROUP BY 列名1 HAVING COUNT(列名2) > 10; 6. JOIN子句，用于在多个表之间建立关联。例如，SELECT FROM 表名1 INNER JOIN 表名2 ON 表名1.列名 = 表名2.列名; 7. UNION操作符，用于合并两个或多个SELECT语句的结果集。例如，SELECT 列名1 FROM 表名1 UNION SELECT 列名2 FROM 表名2; 8. INSERT INTO语句，用于向数据库表中插入新记录。例如，INSERT INTO 表名 (列1, 列2) VALUES (值1, 值2); 9. UPDATE语句，用于更新数据库表中的记录。

例如，UPDATE 表名 SET 列名 = 值 WHERE 条件; 10. DELETE FROM语句，用于从数据库表中删除记录。例如，DELETE FROM 表名 WHERE 条件; 以上是一些常见的SQL查询语句，它们可以帮助用户从数据库中检索、过滤、排序、分组和更新数据。当然，SQL语言还有很多其他的功能和语法，这些只是其中的一部分。希望这些信息能够对你有所帮助。

ACCESS数据库中常见的SQL语句(大全)教程

ACCESS数据库的SQL语句教学 1、查询所有记录：Select *通常用于快速查看表中的记录。当对表的结构无法确切记忆时，或要快速查看表中的记录时，使用Select *是很方便的。 use 企业销售管理系统 Select * from 职工 2、投影查询：很多时候并不需要将所有列的数据都显示出来。投影查询就是允许用户显示所需要的列。假设显示职工表中职工号、姓名、工资信息，具体操作方法如下。 Select 职工号,姓名,工资from 职工在Select查询中，还可以按照实际的需要或自己的喜好安排显示列的顺序，如果要把姓名放到第一列，则代码如下： Select 姓名, 职工号,工资from 职工 3、条件查询：显示wh1或wh2仓库、性别不为女、工资在1300～2100之间的职工信息。具体操作如下： Select * from 职工号where(仓库号='wh1' or 仓库号='wh2') And not 性别='女' and 工资>=1300 and 工资<=2100 在这里一定要注意，(仓库号='wh1' or仓库号='wh2')一定要加括号，否则就不是原题的意思。 4、谓词In查询：在查找特定条件的数据时，如果条件较多，就需要用到多个Or运算符，以查找满足其中任一条的记录。但使用多个Or运算符，将使Where子句变得过于冗长，这时

使用In就非常清楚。另外，在后面讲解的嵌套查询中，也必须使用In查询。下面以显示zg1、zg2、zg11、zg15的订购单信息为例具体讲解一下。使用Or运算符 Select * from 订购单where 职工号='zg1' or 职工号='zg2' Or 职工号='zg11' or 职工号='zg15' 使用谓词In Use 企业销售管理系统 Select * from 订购单where 职工号in('zg1', 'zg2', 'zg11', 'zg15') 在Select语句中，还支持In与Not结合使用。假设显示职工号不为zg1, zg2, zg11, zg15的订购单信息，具体代码如下：使用Or运算符 Select * from 订购单where 职工号!='zg1' or 职工号!='zg2' Or 职工号!='zg11' or 职工号!='zg15' 使用谓词In Use 企业销售管理系统 Select * from 订购单where 职工号not in('zg1', 'zg2', 'zg11', 'zg15') 5、模糊Like查询：有的时候，我们不清楚所要查询的信息，如显示职工信息，但不能确定该职工的姓名，只知道他姓名中含有“王”字，那该如何查找呢？SQL中提供了Like关键字，使用Like进行了查询时，还要指定通配符。通配符及其含义

全球国家地区数据库 sql 英文版

全球国家地区数据库 SQL 英文版 I. Introduction In today's interconnected world, having access to a reliable andprehensive database of global countries and regions is essential for many businesses and organizations. An SQL database that provides information on countries, regions, and their related data is an invaluable resource for a wide range of applications, from emerce and logistics to international relations and academic research. In this article, we will explore the benefits of having a global country and region database in English, the key features and functionalities of such a database, and how it can be implemented and utilized. II. The Importance of a Global Country and Region Database 1. Facilitates International Business: Forpanies engaged in international trade, having access to accurate and up-to-date information on countries and regions is crucial for market research, supply ch本人n management, andpliance with import/export regulations. 2. Supports Geographic Analysis: Geographic information is integral to many fields, including urban planning, environmental science, and public health. A country and region database

数据库用SQL语法大全

数据库用SQL语法大全１、建表格： create table table_name( column1 datatype [not null] [not null primar y key], column2 datatype [not null],...）说明： datatype --是资料的格式，详见表。 nut null --可不可以允许资料有空的（尚未有资料填入）。 primary key --是本表的主键。２、更改表格 alter table table_name add column column_name datatype 说明：增加一个栏位（没有删除某个栏位的语法。) lter table table_name add primary key (column_name) 说明：更改表得的定义把某个栏位设为主键。 alter table table_name drop primary key (column_name) 说明：把主键的定义删除。３、建立索引 create index index_name on table_name (column_name) 说明：对某个表格的栏位建立索引以增加查询时的速度。４、删除 drop table_name drop index_name 二、资料形态datatypes smallint 16 位元的整数。

interger 32 位元的整数。 decimal(p,s) p 精确值和s 大小的十进位整数，精确值p是指全部有几个数(digits)大小值，s是指小数後有几位数。如果没有特别指定，则系统会设为p=5; s=0 。 float 32位元的实数。 double 64位元的实数。 char(n) n 长度的字串，n不能超过254。 varchar(n) 长度不固定且其最大长度为n 的字串，n不能超过4000。 graphic(n) 和 char(n) 一样，不过其单位是两个字元 double-bytes， n不能超过127。这个形态是为支援两个字元长度的字体，例如中文字。 vargraphic(n) 可变长度且其最大长度为 n 的双字元字串，n不能超过 2000。 date 包含了年份、月份、日期。 time 包含了小时、分钟、秒。 timestamp 包含了年、月、日、时、分、秒、千分之一秒。三、资料操作 dml（data manipulation language) 资料定义好之後接下来的就是资料的操作。资料的操作不外乎增加资料（insert)、查询资料（query）、更改资料（update) 、删除资料（delete）四种模式，以下分别介绍他们的语法：１、增加资料： insert into table_name (column1,column2,...) values ( value1,value2, ...)

数据库基本SQL语句大全【范本模板】

数据库基本SQL语句大全数据库基本--—-SQL语句大全一、基础 1、说明:创建数据库 Create DATABASE database—name 2、说明：删除数据库 drop database dbname 3、说明：备份sql server —-- 创建备份数据的device USE master EXEC sp_addumpdevice 'disk', ’testBack’, 'c:\mssql7backup\MyNwind_1。dat’ ———开始备份 BACKUP DATABASE pubs TO testBack 4、说明：创建新表 create table tabname(col1 type1 ［not null] [primary key],col2 ty pe2 [not null］，。.) 根据已有的表创建新表： A：create table tab_new like tab_old （使用旧表创建新表) B：create table tab_new as select col1，col2…from tab_old defin ition only 5、说明:删除新表 drop table tabname 6、说明:增加一个列 Alter table tabname add column col type 注：列增加后将不能删除。DB2中列加上后数据类型也不能改变,唯一能改变的是增加varchar类型的长度。 7、说明：添加主键: Alter table tabname add primary key(col）说明：删除主键: Alter table tabname drop primary key(col) 8、说明：创建索引:create ［unique］index idxname on tabname(col….）删除索引：drop index idxname 注：索引是不可更改的，想更改必须删除重新建。 9、说明：创建视图：create view viewname as select statement

全国省市县SQL数据库(大全)

全国省市县SQL数据库(大全)

数据库SQL查询语句大全

计算机三级数据库SQL语句大全

中国省市区三级数据库表.sql

全国省市区县大全

Microsoft Access数据库中SQL语句大全

sql数据库查询语句

数据库SQL查询语句大全

sql 数据库省市区数据建表和数据

全国省市县三级联动(数据完整版)

数据库sql查询语句大全

ACCESS数据库中常见的SQL语句(大全)教程

全球国家地区数据库 sql 英文版

数据库用SQL语法大全

数据库基本SQL语句大全【范本模板】

相关文档

最新文档

全国省市县SQL数据库(大全)

全国省市县SQL数据库(大全)

数据库SQL查询语句大全

计算机三级数据库SQL语句大全

中国省市区三级数据库表.sql

全国省市区县大全

Microsoft Access数据库中SQL语句大全

sql数据库查询语句

数据库SQL查询语句大全

sql 数据库 省市区 数据建表和数据

全国省市县三级联动(数据完整版)

数据库sql查询语句大全

ACCESS数据库中常见的SQL语句(大全)教程

全球国家地区数据库 sql 英文版

数据库用SQL语法大全

数据库基本SQL语句大全【范本模板】

相关文档

最新文档

sql 数据库省市区数据建表和数据