如果使用sql 语句在studentsdb 数据库创建数据表stusent_info.curriculum、grade
时间: 2025-01-21 07:31:56 浏览: 41
要在`studentsdb`数据库中创建`stusent_info`表以及相关的`curriculum`和`grade`表,你可以使用以下的SQL语句:
```sql
-- 创建stusent_info表
CREATE TABLE studentsdb.stusent_info (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
age INT,
gender VARCHAR(10)
);
-- 创建curriculum表
CREATE TABLE studentsdb.curriculum (
id INT AUTO_INCREMENT PRIMARY KEY,
subject VARCHAR(100) NOT NULL,
teacher VARCHAR(100),
credits INT
);
-- 创建grade表
CREATE TABLE studentsdb.grade (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id INT,
curriculum_id INT,
grade VARCHAR(10),
FOREIGN KEY (student_id) REFERENCES studentsdb.stusent_info(id),
FOREIGN KEY (curriculum_id) REFERENCES studentsdb.curriculum(id)
);
```
这些SQL语句分别创建了`stusent_info`表、`curriculum`表和`grade`表,并在`grade`表中设置了外键约束,以关联`stusent_info`表和`curriculum`表。
阅读全文
相关推荐


















