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 */SETNAMES utf8mb4;SETFOREIGN_KEY_CHECKS0;-- ------------------------------ Table structure for class-- ----------------------------DROPTABLEIFEXISTSclass;CREATETABLEclass(classNochar(6)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT班级编号,classNamevarchar(20)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT班级名称,departmentvarchar(30)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT院系,gradeint(8)NULLDEFAULTNULLCOMMENT年级,numberint(10)NULLDEFAULTNULLCOMMENT人数,PRIMARYKEY(classNo)USINGBTREE)ENGINEInnoDBCHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of class-- ------------------------------ ------------------------------ Table structure for course-- ----------------------------DROPTABLEIFEXISTScourse;CREATETABLEcourse(courseNochar(6)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,courseNamevarchar(20)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,pointint(11)NOTNULL,hourint(11)NOTNULL,termchar(2)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULL,leadchar(6)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULL,PRIMARYKEY(courseNo)USINGBTREE)ENGINEInnoDBCHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of course-- ------------------------------ ------------------------------ Table structure for score-- ----------------------------DROPTABLEIFEXISTSscore;CREATETABLEscore(scoreIDint(11)NOTNULLAUTO_INCREMENT,studentNochar(10)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,courseNochar(6)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,resultfloat(5,2)NULLDEFAULTNULL,PRIMARYKEY(scoreID)USINGBTREE,INDEXstudentNo(studentNo)USINGBTREE,INDEXcourseNo(courseNo)USINGBTREE,CONSTRAINTscore_ibfk_1FOREIGNKEY(studentNo)REFERENCESstudent(studentNo)ONDELETERESTRICTONUPDATERESTRICT,CONSTRAINTscore_ibfk_2FOREIGNKEY(courseNo)REFERENCEScourse(courseNo)ONDELETERESTRICTONUPDATERESTRICT)ENGINEInnoDBAUTO_INCREMENT1CHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of score-- ------------------------------ ------------------------------ Table structure for student-- ----------------------------DROPTABLEIFEXISTSstudent;CREATETABLEstudent(studentNochar(10)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,studentNamevarchar(20)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,genderchar(2)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLDEFAULT男,birthdaydateNULLDEFAULTNULL,addressvarchar(20)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULT河北省石家庄市,nationalvarchar(10)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULT汉,phonevarchar(20)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULL,classNOchar(6)CHARACTERSETutf8COLLATEutf8_general_ciNULLDEFAULTNULL,PRIMARYKEY(studentNo)USINGBTREE,INDEXclassNO(classNO)USINGBTREE,CONSTRAINTstudent_ibfk_1FOREIGNKEY(classNO)REFERENCESclass(classNo)ONDELETERESTRICTONUPDATERESTRICT)ENGINEInnoDBCHARACTERSETutf8COLLATEutf8_general_ci ROW_FORMATDynamic;-- ------------------------------ Records of student-- ----------------------------SETFOREIGN_KEY_CHECKS1;