以下是创建student数据表并添加十条数据的SQL语句:

CREATE TABLE student ( id VARCHAR(2), name VARCHAR(20), birth DATE, sex VARCHAR(2) );

INSERT INTO student (id, name, birth, sex) VALUES ("01", "亚索", "1990-01-01", "男"), ("02", "盖伦", "1992-05-23", "男"), ("03", "艾希", "1993-09-12", "女"), ("04", "卡特琳娜", "1991-02-14", "女"), ("05", "易大师", "1995-07-08", "男"), ("06", "劫", "1994-11-11", "男"), ("07", "菲奥娜", "1996-04-25", "女"), ("08", "卡蜜尔", "1997-12-03", "女"), ("09", "莫甘娜", "1990-03-17", "女"), ("10", "李青", "1992-08-23", "男")


原文地址: https://www.cveoy.top/t/topic/haZr 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录