加入新数据.sql

来自「Sql数据库的应用」· SQL 代码 · 共 18 行

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