SQL 创建 Student 数据表并添加数据

CREATE TABLE Student ( id CHAR(2) NOT NULL, name VARCHAR(20) NOT NULL, birth DATE NOT NULL, sex VARCHAR(2) NOT NULL, t_id INT, PRIMARY KEY (id) );

INSERT INTO Student (id, name, birth, sex, t_id) VALUES ('01', '张三', '1990-01-01', '男', 1), ('02', '李四', '1992-05-20', '女', 2), ('03', '王五', '1991-07-15', '男', 3);