MySQL学习第一章笔记-2026-3-11前两节学习——建表＋外键任务＋默认值+保存的数据和保存方式

MySQL学习第一章笔记-2026-3-11前两节学习——建表＋外键任务＋默认值+保存的数据和保存方式

• 1.任务清单
• 1.技巧
• 2.外键添加教程
• 3保存的内容以及保存方式和使用方式

1.任务清单

1.技巧

上下键可以直接添加字段 tab键可以横向选中和补全

2.外键添加教程

1.明确谁是主表谁是从表，删除时先删除从表，在删除主表。

3保存的内容以及保存方式和使用方式

方式，在全选后选择转储SQL文件然后就可以了

使用数据,用的是候直接把代码放到新建查询中运行就好，

拿取数据：代码粘贴的是用记事本打开的导出文件。

/*
Navicat Premium Data Transfer

Source Server : MySQLDB
Source Server Type : MySQL
Source Server Version : 50731
Source Host : localhost:3306
Source Schema : schooldb

Target Server Type : MySQL
Target Server Version : 50731
File Encoding : 65001

Date: 11/03/2026 12:05:42
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

— —————————-
— Table structure for class
— —————————-
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
`classNo` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级编号',
`className` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '班级名称',
`department` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '院系',
`grade` int(8) NULL DEFAULT NULL COMMENT '年级',
`number` int(10) NULL DEFAULT NULL COMMENT '人数',
PRIMARY KEY (`classNo`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of class
— —————————-

— —————————-
— Table structure for course
— —————————-
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`courseNo` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`courseName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`point` int(11) NOT NULL,
`hour` int(11) NOT NULL,
`term` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`lead` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`courseNo`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of course
— —————————-

— —————————-
— Table structure for score
— —————————-
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
`scoreID` int(11) NOT NULL AUTO_INCREMENT,
`studentNo` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`courseNo` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`result` float(5, 2) NULL DEFAULT NULL,
PRIMARY KEY (`scoreID`) USING BTREE,
INDEX `studentNo`(`studentNo`) USING BTREE,
INDEX `courseNo`(`courseNo`) USING BTREE,
CONSTRAINT `score_ibfk_1` FOREIGN KEY (`studentNo`) REFERENCES `student` (`studentNo`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `score_ibfk_2` FOREIGN KEY (`courseNo`) REFERENCES `course` (`courseNo`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of score
— —————————-

— —————————-
— Table structure for student
— —————————-
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`studentNo` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`studentName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`gender` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男',
`birthday` date NULL DEFAULT NULL,
`address` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '河北省石家庄市',
`national` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '汉',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`classNO` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`studentNo`) USING BTREE,
INDEX `classNO`(`classNO`) USING BTREE,
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`classNO`) REFERENCES `class` (`classNo`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

— —————————-
— Records of student
— —————————-

SET FOREIGN_KEY_CHECKS = 1;