![](https://iknow-base.cdn.bcebos.com/lxb/notice.png)
求大神速速解答 我在考试 这是数据库卷子 有懂得帮我解决一哈。。。不会的请绕道 非诚勿扰 30
2个回答
展开全部
机试还是笔试哟这!
2.create table XS(stuno char(6) not null,name char(8) not null,zyname char(10),sex char(10) not null default '男',borntime smalldatetime(4) not null,points tinyint(1),option text(16))
另外两个表照着弄
3.alter table XS add constrain con_XS primary key(stuno) references xs_kc(stuno)
另外两个照着弄
4.insert into XS values('001101','王林','计算机','男','1993-3-1 0:00:00',50,'看不清')
另外两个照着弄吧
5.select KC.kcname as kcname,cs_kc.score as score from XS,KC,xs_kc where XS.name='王林' and XS.stuno=xs_kc.stuno and KC.kcno=xs_kc.kcno
6.select * from XS where sex='男'
2.create table XS(stuno char(6) not null,name char(8) not null,zyname char(10),sex char(10) not null default '男',borntime smalldatetime(4) not null,points tinyint(1),option text(16))
另外两个表照着弄
3.alter table XS add constrain con_XS primary key(stuno) references xs_kc(stuno)
另外两个照着弄
4.insert into XS values('001101','王林','计算机','男','1993-3-1 0:00:00',50,'看不清')
另外两个照着弄吧
5.select KC.kcname as kcname,cs_kc.score as score from XS,KC,xs_kc where XS.name='王林' and XS.stuno=xs_kc.stuno and KC.kcno=xs_kc.kcno
6.select * from XS where sex='男'
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询