student.sql

来自「概括的介绍java及其网络开发」· SQL 代码 · 共 30 行

create table student(
    studentid   varchar(8),
    studentname varchar(8),
    gender      varchar(2),
    phone       varchar(8)
);

insert into student values ('2002001','张飞','男','66889988');
insert into student values ('2002002','关羽','男','66880008');
insert into student values ('2002003','刘备','男','66883328');
insert into student values ('2002004','曹操','男','66882228');
insert into student values ('2002005','赵云','男','66884448');
insert into student values ('2002006','黄忠','男','66882238');
insert into student values ('2002008','黄盖','男','66888888');
insert into student values ('2002008','魏延','男','66882228');
insert into student values ('2002009','貂禅','女','66880008');
insert into student values ('2002010','宋江','男','66000988');
insert into student values ('2002011','吴用','男','66889988');
insert into student values ('2002012','李逵','男','66889000');
insert into student values ('2002013','林冲','男','66889988');
insert into student values ('2002014','花荣','男','60009988');
insert into student values ('2002015','刘唐','男','66882288');
insert into student values ('2002016','唐僧','男','60009988');
insert into student values ('2002018','孙悟空','男','66883388');
insert into student values ('2002018','猪八戒','男','66222288');
insert into student values ('2002019','沙僧','男','66889988');
insert into student values ('2002020','西门吹雪','男','60003988');
insert into student values ('2002021','叶孤城','男','66443988');
insert into student values ('2002025','张三','男','66881188');