:
insert into < >(< >) values (< >)
53 , ball , :
insert into ball (stud._nom.er, dis, dat, form, res) values ('010001', ' ', '29.12.2003', '', 85)
- , , , NULL, .
54 ,
insert into ball(stud_nomer, dis, dat, res) values ('010001', ' ', '29.12.2003', 85)
010001 , 04-01.2004 100
insert into ball(stud_nomer, dis) values ('010001', ' ')
010001 NULL NULL
insert into ball(stud_nomer) values ('010001')
, , dis , NULL .
87 () , - .
88 () , , .
89 (CD) .
90 () , .
:
delete from < > [where <>]
, . , , .
55 , ball '010001', , :
delete from ball where stud_nomer = '010001'
, where select.
91 () , - , ( , ).
92 (CD) .
93 () , .
94 () , - , , , , , .
:
update < >
set < > = <> [,< > = <> [,... ]] [where <>]
set . where, , , .
|
|
56 , , '010001' '010010', , student ball:
update student set nomer = '010010' where nomer='010001'
update ball set stud_nomer = '010010' where stud_nomer='010001'
.
57 5, :
update ball set res = res + 5 where dis = '' and form = ''
select, where delete update .
58 , , , , 100 , . :
update ball set res = 100
where dis = '' and form = '' and res = any(select max(res) from ball
where dis = '' and form = '')
95 () , , .
96 () , , 5% , 1000.
97 () , .
98 () , . 10000 , - .., .
99 () , 10000 , - .., . , .