2022年关于MySQL语句建表的总结(2).docx

2022年关于MySQL语句建表的总结(2)

　　写了几个表，里面包括外键主键的设置，建表语句如下：USEtestdatabase;
　　CREATETABLEclass(
　　class_idINTEGERUNSIGN2022年关于MySQL语句建表的总结(2)

　　写了几个表，里面包括外键主键的设置，建表语句如下：USEtestdatabase;
　　CREATETABLEclass(
　　class_idINTEGERUNSIGNEDAUTO_INCREMENTPRIMARYKEY,class_nameVARCHAR(40));
　　CREATETABLEstudent(
　　student_idINTEGERUNSIGNEDNOTNULLAUTO_INCREMENT,PRIMARYKEY(student_id),
　　student_namevarchar(40),
　　class_idINTEGERUNSIGNED,
　　CONSTRAINTFK_student_classFOREIGNKEY(class_id)REFERENCESclass(class_id)ONDELETECASCADEONUPDATECASCADE);
　　CREATETABLElession(
　　lession_idINTEGERUNSIGNEDNOTNULLAUTO_INCREMENT,PRIMARYKEY(lession_id),lession_namevarchar(40));
　　CREATETABLEcore(
　　core_idINTEGERUNSIGNEDAUTO_INCREMENT,lession_idINTEGERUNSIGNEDNOTNULL,student_idINTEGERUNSIGNEDNOTNULL,coreFLOAT,
　　close_statusINTEGERDEFAULT0,CONSTRAINTPK_corePRIMARYKEY(core_id),CONSTRAINTFK_core_lessionFOREIGNFOREIGN
　　KEY(lession_id)KEY(student_id)
　　REFERENCESREFERENCES
　　lession(lession_id),
　　CONSTRAINTFK_core_studentstudent(student_id)
　　ONDELETECASCADE);
　　CREATETABLEteacher(
　　teacher_idINTEGERUNSIGNEDNOTNULLAUTO_INCREMENT,PRIMARYKEY(teacher_id),teacher_namevarchar(40));
　　CREATETABLEteachlession(
　　teachlession_idINTEGERPRIMARYKEYAUTO_INCREMENT,lession_idINTEGERUNSIGNED,teacher_idINTEGERUNSIGNED,
　　CONSTRAINTFK_teachlession_lessionFOREIGNKEY(lession_id)REFERENCESlessio