O’zbekiston respublikasi axborat texnologiyalari va kommunikatsiyalarini rivojlantirishvazirligi muhammad al-xorazmiy nomidagi toshkent axborat texnologiyalari univesiteti ma’lumotlar bazasi fanidan Amaliy ish


Master jadvalidagi o’zgarishni ham ko’ramiz; 14.11 – rasm


Download 1.89 Mb.
bet9/9
Sana06.04.2023
Hajmi1.89 Mb.
#1334315
1   2   3   4   5   6   7   8   9
Bog'liq
Sherzod baza

14.4. Master jadvalidagi o’zgarishni ham ko’ramiz;

14.11 – rasm. Master jadvalidagi Update operatorini qo`llagandan keying o`zgarishlar
3. Before insert trigger:

    1. master_kiritish_oldin triggerini yaratamiz.


14.12– rasm. Master_kiritish_oldin triggerini yaratish so`rovi

    1. Yaratgan triggerimizni ishlatamiz va natijasini master0 jadvalida ko’ramiz; ya’ni biz trigger yordamida yangi satr kiritdik.


14.13 – rasm. Master_kiritish_oldin triggerni ishlashi natijasi
14.5. After insert trigger
14.5.1. Master_kiritish_keyin triggerini yaratamiz.

14.17– rasm. Master_kiritish_keyin triggerini yaratish so`rovi

      1. Yaratgan triggerimizni ishlatamiz va natijasini master0 jadvalida ko’ramiz; ya’ni biz trigger yordamida yana yangi satr kiritdik.


14.14 – rasm. Master_kiritish_keyin triggerining ishlash natijasi
5. Before delete trigger

    1. Master_ochirish_oldin triggerini yaratamiz;


14.15 – rasm. Master_ochirish_oldin triggerini yaratish

    1. Yaratgan triggerimizni ishlatamiz va natijasini master0 jadvalida ko’ramiz; ya’ni biz trigger yordamida ID 5 ga teng satrni o’chirdik.


14.16 – rasm. Master0 jadvalidan satr o`chirish natijasi
6. After delete trigger
6.1. Master_ochirish_keyin triggerini yaratamiz;

14.17– rasm. Master_ochirish_keyin triggerini yaratish

    1. Yaratgan triggerimizni ishlatamiz va natijasini master0 jadvalida ko’ramiz; yani biz trigger yordamida ID 1 ga teng satrni ham o’chirdik.


14.18 – rasm. Master0 jadvalidan satr o`chirish natijasi
7. drop trigger:
7.1. Oldingi misollarda yaratgan master_ochirish_oldin triggerini o’chiramiz;

14.19– rasm. Ma’lumotlar bazasidagi triggerni o’chirish
Download 1.89 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6   7   8   9




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling