, , SQL- , , . , , .
59 , analisys ( 50) . , , :
delete from analysis where stud_nomer = '010001' :
update analysis set dat = '07.01.2004'
, ball , , dat '07.01.2004' ball, analysis.
insert. . : . , analysis 3 ball. ,
insert into analysis(stud_nomer, dat, res) values ('011101', '04.01.2004', 60)
dis form ball. NULL, . form (''), dis NULL. dis NULL, .
, .
60 , analysis :
create view analysis as select stud_nomer, dis, dat, res from ball where dis = ''
, dis '':
insert into analysis(stud_nomer, dis, dat, res) values('011101', '', '15.01.2004', 6)
, ball. analysis , , . , , . update: , .
, with check option:
create view as... with check option
, , , .
61 ,
create view analysis as select stud_nomer, dis, dat, res from ball where dis = '' with check option
To , insert 60 . analysis , , . ,
|
|
update analysis set dis = ''
.
100 () , , , ..
101 () , , , Ȼ λ.
102 () , , 10 19.