- 查询所有学生数据,主外键关联查询
-- Table structure for `class`
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
`cid` int(50) NOT NULL AUTO_INCREMENT,
`cname` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of class
-- ----------------------------
INSERT INTO `class` VALUES ('1', '1001');
INSERT INTO `class` VALUES ('2', '1002');
INSERT INTO `class` VALUES ('3', '1003');
INSERT INTO `class` VALUES ('4', '1004');
-- Table structure for `student`
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`sid` int(50) NOT NULL AUTO_INCREMENT,
`sname` varchar(50) COLLATE utf8_bin NOT NULL,
`ssex` varchar(50) COLLATE utf8_bin NOT NULL,
`sage` varchar(50) COLLATE utf8_bin NOT NULL,
`scid` int(50) NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', '星 星', '男', '20', '1');
INSERT INTO `student` VALUES ('2', '猪八戒', '男', '33', '3');
INSERT INTO `student` VALUES ('3', '施耐庵', '男', '37', '2');
INSERT INTO `student` VALUES ('4&