创建数据表 data_table_2_1 并添加数据 - SQL 示例

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

INSERT INTO data_table_2_1 (id, name, birth, sex, t_id) VALUES ('01', '张三', '1990-01-01', '男', '01'), ('02', '李四', '1991-02-02', '男', '02'), ('03', '王五', '1992-03-03', '男', '03'), ('04', '赵六', '1993-04-04', '女', '04'), ('05', '孙七', '1994-05-05', '女', '05'), ('06', '周八', '1995-06-06', '男', '06'), ('07', '吴九', '1996-07-07', '女', '07'), ('08', '郑十', '1997-08-08', '男', '08'), ('09', '钱十一', '1998-09-09', '女', '09'), ('10', '朱十二', '1999-10-10', '男', '10');