SQL创建学生表并添加数据：student 表结构和示例数据

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

INSERT INTO student (id, name, birth, sex, t_id) VALUES ('01', '张三', '2000-01-01', '男', 1), ('02', '李四', '2000-02-02', '女', 2), ('03', '王五', '2000-03-03', '男', 3), ('04', '赵六', '2000-04-04', '女', 4), ('05', '钱七', '2000-05-05', '男', 5), ('06', '孙八', '2000-06-06', '女', 6), ('07', '周九', '2000-07-07', '男', 7), ('08', '吴十', '2000-08-08', '女', 8), ('09', '郑十一', '2000-09-09', '男', 9), ('10', '卫十二', '2000-10-10', '女', 10);