示例语句:
1. 创建学生表:
CREATE TABLE student (
no CHAR(5) NOT NULL UNIQUE,
name CHAR(20),
sex CHAR(2),
age INT,
dept CHAR(15)
);
- 创建课程表:
CREATE TABLE course (
seq CHAR(4),
subject CHAR(15),
credit INT
);
- 创建学生选修表:
CREATE TABLE choose_course (
no CHAR(5),
seq CHAR(4),
grade INT
);