【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:加入新数据.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
insert into student
(id,name,gender,grade,class)
values('yx2005001','何子巍',0,2005,1)
insert into student
(id,name,gender,grade,class)
values('yx2005008','李子米',1,2005,1)
insert into Score
select a.id,b.id,90,1,1
from student a,course b
where a.id='yx2005001'
select *
from score
select *
from student