Fizika-matematika fakulteti

1 ... 36 37 38 39 40 41 42 43 ... 86

Bog'liq
sql tilini oqitishda usulbiy xususiyatlar taxlili

[WHERE search-condition]

bu erda expression - bu ustun | ifoda | konstanta | o‗zgaruvchi.

Ikkinchi variant:

UPDATE

        SET  column = expression, ...

           [ FROM  table-list ]

        [ WHERE search-condition ]

Masalan, hamma buyurtmachilar baxosini 200 ga o‗zgartirish uchun

quyidagini kiritishingiz mumkin:

UPDATE Customers

SET Rating = 200;

Ma‘lum satrlarni o‗zgartirish uchun DELETE dagi kabi predikatdan

foydalanish kerak. Masalan Peel ( imeyushego SNum=11 ) sotuvchining hamma

buyurtmachilari uchun bir xil o‗zgartirishni quyidagicha kiritish mumkin vыpolnit:

Download 1.36 Mb.

Do'stlaringiz bilan baham:

1 ... 36 37 38 39 40 41 42 43 ... 86