25 lines
657 B
SQL
25 lines
657 B
SQL
create table reader (
|
|
number varchar(10) primary key,
|
|
name varchar(20),
|
|
gender varchar(8),
|
|
age integer,
|
|
major varchar(20)
|
|
);
|
|
|
|
INSERT INTO
|
|
reader
|
|
VALUES
|
|
("20090005", "john", "male", 22, "math"),
|
|
("20090007", "sunnny", "male", 25, "medicine"),
|
|
("20090008", "lee", "male", 21, "medicine"),
|
|
("20090009", "nancy", "male", 26, "math"),
|
|
("20090010", "Billy", "female", 24, "science"),
|
|
("20090011", "tina", "female", 23, "physics"),
|
|
("20090012", "bunny", "female", 23, "physics"),
|
|
("20090013", "daisy", "female", 21, "science"),
|
|
("20090014", "henry", "male", 12, "science");
|
|
|
|
select
|
|
*
|
|
from
|
|
reader; |