网站首页
编程语言
数据库
系统相关
其他分享
编程问答
SchoolDB
2024-10-23
SchoolDB字段创建添加约束以及主键
--SchoolDB字段创建添加约束以及主键CREATEDATABASESchoolDB;USESchoolDB;CREATETABLEGrade(gradeIdINT(4)NOTNULL,gradeNameVARCHAR(50)NOTNULL,PRIMARYKEY(gradeId));CREATETABLESubject(subjectIdINT(4)NOTNULL,subjectNameVARCHAR(20),classH
2024-10-23
schooldb字段创建添加约束以及主键
--schooldb字段创建添加约束以及主键创建数据库和表(之前已经创建的部分)CREATEDATABASESchoolDB;USESchoolDB;CREATETABLEGrade(gradeIdINT(4)NOTNULL,gradeNameVARCHAR(50)NOTNULL,PRIMARYKEY(gradeId));CREATETABLESubject(subjectIdINT(4)NOTNULL,