创建 Couse 数据表并添加数据 - SQL 实例

CREATE TABLE course ( id VARCHAR(2) PRIMARY KEY, name VARCHAR(20), birth DATE, sex VARCHAR(2) );

INSERT INTO course (id, name, birth, sex) VALUES ('01', '张三', '1900-01-01', '男'), ('02', '李四', '1995-05-12', '男'), ('03', '王五', '1987-09-23', '男'), ('04', '赵六', '2000-11-30', '女'), ('05', '钱七', '1978-03-05', '女'), ('06', '孙八', '1992-07-15', '男'), ('07', '周九', '1985-12-25', '女'), ('08', '吴十', '1970-06-18', '男'), ('09', '郑十一', '1998-02-28', '女'), ('10', '陈十二', '1982-04-14', '男');