SQL语句创建学生表、课程表和中间表并添加测试数据

创建学生表student的SQL语句：\n\nsql\nCREATE TABLE student (\n Stuid INT PRIMARY KEY AUTO_INCREMENT,\n StuName VARCHAR(50) NOT NULL,\n StuGender VARCHAR(2) DEFAULT '男',\n StuAge INT CHECK (StuAge >= 0),\n StuEmail VARCHAR(50) UNIQUE\n);\n\n\n添加五条测试数据的SQL语句：\n\nsql\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('张三', '男', 18, 'zhangsan@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('李四', '女', 20, 'lisi@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('王五', '男', 22, 'wangwu@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('赵六', '女', 19, 'zhaoliu@example.com');\nINSERT INTO student (StuName, StuGender, StuAge, StuEmail) VALUES ('钱七', '男', 21, 'qianqi@example.com');\n\n\n创建课程表course的SQL语句：\n\nsql\nCREATE TABLE course (\n CourseId INT PRIMARY KEY AUTO_INCREMENT,\n CourseName VARCHAR(50) NOT NULL\n);\n\n\n添加三条测试数据的SQL语句：\n\nsql\nINSERT INTO course (CourseName) VALUES ('数学');\nINSERT INTO course (CourseName) VALUES ('英语');\nINSERT INTO course (CourseName) VALUES ('物理');\n\n\n创建中间表middle_table的SQL语句：\n\nsql\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);\n\n\n添加三条测试数据的SQL语句：\n\nsql\nINSERT INTO middle_table (Stuid, CourseId) VALUES (1, 1);\nINSERT INTO middle_table (Stuid, CourseId) VALUES (1, 2);\nINSERT INTO middle_table (Stuid, CourseId) VALUES (2, 3);\n