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

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

2. 
   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

2. 
   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

2. 
   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