SQL创建学生表和课程表并添加测试数据

1、创建学生表student：\n\nCREATE TABLE student (\n Stuid INT PRIMARY KEY AUTO_INCREMENT,\n StuName VARCHAR(50) NOT NULL,\n StuGender VARCHAR(2) DEFAULT '男',\n StuAge INT(2) CHECK (StuAge >= 0),\n StuEmail VARCHAR(50) UNIQUE\n);\n\n2、添加五条测试语句：\n\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('张三', '男', 20, 'zhangsan@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('李四', '女', 19, 'lisi@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('王五', '男', 21, 'wangwu@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('赵六', '女', 18, 'zhaoliu@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('钱七', '男', 22, 'qianqi@example.com');\n\n3、创建课程表course：\n\nCREATE TABLE course (\n CourseId INT PRIMARY KEY AUTO_INCREMENT,\n CourseName VARCHAR(50) NOT NULL\n);\n\n4、添加三条测试语句：\n\nINSERT INTO course (CourseName) VALUES ('数学');\nINSERT INTO course (CourseName) VALUES ('英语');\nINSERT INTO course (CourseName) VALUES ('物理');\n\n5、创建学生和课程的中间表middle_table：\n\nCREATE TABLE middle_table (\n Stuid INT,\n CourseId INT,\n PRIMARY KEY (Stuid, CourseId),\n FOREIGN KEY (Stuid) REFERENCES student(Stuid) ON DELETE CASCADE,\n FOREIGN KEY (CourseId) REFERENCES course(CourseId) ON DELETE CASCADE\n);