>[danger] 数据表 学生表  学院表  >[danger] 创建数据表 ``` -- 学生表 DROP TABLE IF EXISTS student; CREATE TABLE `student` ( `studentId` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '学号,主键', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '姓名', `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '电话', `collegeId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '学生所在学院ID,外键', PRIMARY KEY (`studentId`), KEY `collegeId` (`collegeId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT '学生表'; INSERT INTO `student` VALUES (1, '张三', 139, 11), (2, '李四', 130, 22), (3, '王五', 136, 33), (4, '赵六', 136, NULL), (5, '钱七', 135, NULL); -- 学院表 DROP TABLE IF EXISTS college; CREATE TABLE `college` ( `collegeId` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '学院ID,主键', `collegeName` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '学院名', PRIMARY KEY (`collegeId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT '学院表'; INSERT INTO `college` VALUES (44, '厦大'), (11, '清华'), (22, '北大'), (33, '浙大'); SELECT * FROM `student`; SELECT * FROM `college`; ```