增加标 和增加其内容

 create table student(
    sno varchar(20) not null comment'学号',
    sname varchar(20) not null comment'学生姓名',
    ssex varchar(20) not null comment'学生性别',
    sbirthday datetime comment'学生出生年月',
    class varchar(20) comment '学生所在班级',
    primary key(sno)
  );
     
  create table course(
     cno varchar(20) comment'课程号',
      cname varchar(20) comment'课程名称',
      tno varchar(20) comment'教工编号',
      primary key(cno)

set names gbk;
insert into student values
('108','曾华','男','1997-09-01','95033'),
('105','匡明','男','1975-10-02','95031'),
('107','王丽','女','1976-01-23','95033'),
('101','李军','女','1976-02-20','95033'),
('109','王芳','女','1976-02-10','95031'),
('103','陆君','男','1974-06-03','95031');


insert into course values
 ('3-105','计算机导论','825'),
 ('3-245','操作系统','804'),
 ('6-166','数字电路','856'),
 ('9-888','高等数学','831');

posted @ 2018-08-11 15:36  Strif  阅读(88)  评论(0编辑  收藏  举报