>[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`; ```