mysql暑假作业.zip

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50562 Source Host : localhost:3306 Source Schema : test Target Server Type : MySQL Target Server Version : 50562 File Encoding : 65001 Date: 13/06/2022 15:45:23 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for studentinfo -- ---------------------------- DROP TABLE IF EXISTS `studentinfo`; CREATE TABLE `studentinfo` ( `stuId` int(20) NOT NULL AUTO_INCREMENT, `stuName` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `gender` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '男', `age` int(3) NULL DEFAULT NULL, `birthday` date NOT NULL, `studentNO` int(20) NULL DEFAULT NULL, `ClassID` int(10) NULL DEFAULT NULL, `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`stuId`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of studentinfo -- ---------------------------- INSERT INTO `studentinfo` VALUES (10, '王志强', '男', 22, '2001-03-14', 10115, 1012, '安阳', '[email protected]'); INSERT INTO `studentinfo` VALUES (11, '章涵', '男', 20, '2001-03-14', 10116, 1012, '郑州', '[email protected]'); INSERT INTO `studentinfo` VALUES (12, '王立业', '男', 21, '2001-03-14', 10117, 1012, '郑州', '\'[email protected]'); INSERT INTO `studentinfo` VALUES (13, '张磊', '男', 22, '2001-03-14', 10118, 1012, '平顶山', '[email protected]'); INSERT INTO `studentinfo` VALUES (14, '王甫成', '男', 22, '2001-03-14', 10119, 1012, '周口', '[email protected]'); INSERT INTO `studentinfo` VALUES (15, '刘佳琪', '男', 22, '2001-03-14', 10120, 1012, '周口', '[email protected]'); INSERT INTO `studentinfo` VALUES (16, '莫晨阳', '男', 23, '2001-09-08', 1234, 1016, '周口', '[email protected]'); INSERT INTO `studentinfo` VALUES (21, '刘金英', '女', 25, '2001-09-08', 1236, 1016, '平顶山', '[email protected]'); INSERT INTO `studentinfo` VALUES (22, '李成', '男', 23, '2001-09-08', 1235, 1016, '驻马店', '[email protected]'); INSERT INTO `studentinfo` VALUES (23, '刘兰', '女', 29, '2001-09-08', 1237, 1013, '南阳', '[email protected]'); INSERT INTO `studentinfo` VALUES (24, '纳兰嫣然', '男', 20, '2000-09-12', 12309, 1011, '郑州', '[email protected]'); INSERT INTO `studentinfo` VALUES (25, '王伟', '男', 21, '2020-01-01', 12378, 1014, '信阳', '[email protected]'); INSERT INTO `studentinfo` VALUES (26, '张无极', '男', 80, '2020-01-14', 10123, 1013, '武汉', '[email protected]'); SET FOREIGN_KEY_CHECKS = 1;