全国大学名称数据表（含省份、城市、大学名称，三张表相关联）共2217所，MySQL

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50173 Source Host : localhost:3306 Source Database : db_express Target Server Type : MYSQL Target Server Version : 50173 File Encoding : 65001 Date: 2014-11-29 20:05:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `shool_info` -- ---------------------------- DROP TABLE IF EXISTS `shool_info`; CREATE TABLE `shool_info` ( `sh_id` int(10) NOT NULL COMMENT '学校ID值', `sh_city` int(10) NOT NULL COMMENT '城市外键', `sh_shool` varchar(32) NOT NULL COMMENT '学校名称', PRIMARY KEY (`sh_id`), KEY `sh_city` (`sh_city`), CONSTRAINT `shool_info_ibfk_1` FOREIGN KEY (`sh_city`) REFERENCES `city_info` (`ci_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of shool_info -- ---------------------------- INSERT INTO `shool_info` VALUES ('1', '1', '北京大学'); INSERT INTO `shool_info` VALUES ('2', '1', '中国人民大学'); INSERT INTO `shool_info` VALUES ('3', '1', '清华大学'); INSERT INTO `shool_info` VALUES ('4', '1', '北京交通大学'); INSERT INTO `shool_info` VALUES ('5', '1', '北京科技大学'); INSERT INTO `shool_info` VALUES ('6', '1', '北京化工大学'); INSERT INTO `shool_info` VALUES ('7', '1', '北京邮电大学'); INSERT INTO `shool_info` VALUES ('8', '1', '中国农业大学'); INSERT INTO `shool_info` VALUES ('9', '1', '北京林业大学'); INSERT INTO `shool_info` VALUES ('10', '1', '北京中医药大学'); INSERT INTO `shool_info` VALUES ('11', '1', '北京师范大学'); INSERT INTO `shool_info` VALUES ('12', '1', '北京外国语大学'); INSERT INTO `shool_info` VALUES ('13', '1', '北京语言大学'); INSERT INTO `shool_info` VALUES ('14', '1', '中央财经大学'); INSERT INTO `shool_info` VALUES ('15', '1', '对外经济贸易大学'); INSERT INTO `shool_info` VALUES ('16', '1', '中国政法大学'); INSERT INTO `shool_info` VALUES ('17', '1', '华北电力大学'); INSERT INTO `shool_info` VALUES ('18', '1', '中国石油大学'); INSERT INTO `shool_info` VALUES ('19', '1', '中央民族大学'); INSERT INTO `shool_info` VALUES ('20', '1', '中国人民公安大学'); INSERT INTO `shool_info` VALUES ('21', '1', '北京协和医学院'); INSERT INTO `shool_info` VALUES ('22', '1', '北京体育大学'); INSERT INTO `shool_info` VALUES ('23', '1', '北京航空航天大学'); INSERT INTO `shool_info` VALUES ('24', '1', '北京理工大学'); INSERT INTO `shool_info` VALUES ('25', '1', '中国科学院大学'); INSERT INTO `shool_info` VALUES ('26', '1', '北京工业大学'); INSERT INTO `shool_info` VALUES ('27', '1', '北方工业大学'); INSERT INTO `shool_info` VALUES ('28', '1', '北京工商大学'); INSERT INTO `shool_info` VALUES ('29', '1', '北京建筑大学'); INSERT INTO `shool_info` VALUES ('30', '1', '首都医科大学'); INSERT INTO `shool_info` VALUES ('31', '1', '首都师范大学'); INSERT INTO `shool_info` VALUES ('32', '1', '首都经济贸易大学'); INSERT INTO `shool_info` VALUES ('33', '1', '北京信息科技大学'); INSERT INTO `shool_info` VALUES ('34', '1', '北京联合大学'); INSERT INTO `shool_info` VALUES ('35', '1', '中国传媒大学'); INSERT INTO `shool_info` VALUES ('36', '1', '国际关系学院'); INSERT INTO `shool_info` VALUES ('37', '1', '中央音乐学院'); INSERT INTO `shool_info` VALUES ('38', '1', '中央美术学院'); INSERT INTO `shool_info` VALUES ('39', '1', '中央戏剧学院'); INSERT INTO `shool_info` VALUES ('40', '1', '北京电子科技学院'); INSERT INTO `shool_info` VALUES ('41', '1', '外交学院'); INSERT INTO `shool_info` VALUES ('42', '1', '中国劳动关系学院'); INSERT INTO `shool_info` VALUES ('43', '1', '中国青年政治学院'); INSERT INTO `shool_info` VALUES ('44', '1', '中华女子学院'); INSERT INTO `shool_info` VALUES ('45', '1', '北京服装学院'); INSERT INTO `shool_info` VALUES ('46', '1', '北京印刷学院'); INSERT INTO `shool_info` VALUES ('47', '1', '北京石油化工学院'); INSERT INTO `shool_info` VALUES ('48', '1', '北京农学院'); INSERT INTO `shool_info` VALUES ('49', '1', '首都体育学院'); INSERT INTO `shool_info` VALUES ('50', '1', '北京第二外国语学院'); INSERT INTO `shool_info` VALUES ('51', '1', '北京物资学院'); INSERT INTO `shool_info` VALUES ('52', '1', '中国音乐学院'); INSERT INTO `shool_info` VALUES ('53', '1', '中国戏曲学院'); INSERT INTO `shool_info` VALUES ('54', '1', '北京电影学院'); INSERT INTO `shool_info` VALUES ('55', '1', '北京舞蹈学院'); INSERT INTO `shool_info` VALUES ('56', '1', '北京城市学院'); INSERT INTO `shool_info` VALUES ('57', '1', '首钢工学院'); INSERT INTO `shool_info` VALUES ('58', '1', '北京警察学院'); INSERT INTO `shool_info` VALUES ('59', '1', '北京青年政治学院'); INSERT INTO `shool_info` VALUES ('60', '1', '北京工业职业技术学院'); INSERT INTO `shool_info` VALUES ('61', '1', '北京信息职业技术学院'); INSERT INTO `shool_info` VALUES ('62', '1', '北京电子科技职业学院'); INSERT INTO `shool_info` VALUES ('63', '1', '北京吉利大学'); INSERT INTO `shool_info` VALUES ('64', '1', '北京社会管理职业学院'); INSERT INTO `shool_info` VALUES ('65', '1', '北京新圆明职业学院'); INSERT INTO `shool_info` VALUES ('66', '1', '北京体育职业学院'); INSERT INTO `shool_info` VALUES ('67', '1', '北京交通运输职业学院'); INSERT INTO `shool_info` VALUES ('68', '1', '北京卫生职业学院'); INSERT INTO `shool_info` VALUES ('69', '1', '北京京北职业技术学院'); INSERT INTO `shool_info` VALUES ('70', '1', '北京交通职业技术学院'); INSERT INTO `shool_info` VALUES ('71', '1', '北京农业职业学院'); INSERT INTO `shool_info` VALUES ('72', '1', '北京政法职业学院'); INSERT INTO `shool_info` VALUES ('73', '1', '北京财贸职业学院'); INSERT INTO `shool_info` VALUES ('74', '1', '北京北大方正软件职业技术学院'); INSERT INTO `shool_info` VALUES ('75', '1', '北京经贸职业学院'); INSERT INTO `shool_info` VALUES ('76', '1', '北京经济技术职业学院'); INSERT INTO `shool_info` VALUES ('77', '1', '北京戏曲艺术职业学院'); INSERT INTO `shool_info` VALUES ('78', '1', '北京汇佳职业学院'); INSERT INTO `shool_info` VALUES ('79', '1', '北京现代职业技术学院'); INSERT INTO `shool_info` VALUES ('80', '1', '北京科技经营管理学院'); INSERT INTO `shool_info` VALUES ('81', '1', '北京科技职业学院'); INSERT INTO `shool_info` VALUES ('82', '1', '北京培黎职业学院'); INSERT INTO `shool_info` VALUES ('83', '1', '北京经济管理职业学院'); INSERT INTO `shool_info` VALUES ('84', '1', '北京劳动保障职业学院'); INSERT INTO `shool_info` VALUES ('85', '2', '复旦大学'); INSERT INTO `shool_info` VALUES ('86', '2', '同济大学'); INSERT INTO `shool_info` VALUES ('87', '2', '上海交通大学'); INSERT INTO `shool_info` VALUES ('88', '2', '华东理工大学'); INSERT INTO `shool_info` VALUES ('89', '2', '东华大学'); INSERT INTO `shool_info` VALUES ('90', '2', '华东师范大学'); INSERT INTO `shool_info` VALUES ('91', '2', '上海外国语大学'); INSERT INTO `shool_info` VALUES ('92', '2', '上海财经大学'); INSERT INTO `shool_info` VALUES ('93', '2', '上海理工大学'); INSERT INTO `shool_info` VALUES ('94', '2', '上海海事大学'); INSERT INTO `shool_info` VALUES ('95', '2', '上海海洋大学'); INSERT INTO `shool_info` VALUES ('96', '2', '上海中医药大学'); INSERT INTO `shool_info` VALUES ('97', '2', '上海师范大学'); INSERT INTO `shool_info` VALUES ('98', '2', '上海对外经贸大学'); INSERT INTO `shool_info` VALUES ('99', '2', '华东政法大学'); INSERT INTO `shool_info` VALUES ('10