Muhammad al-xorazmiy nomidagi toshkent axborat texnologiyalari univesiteti

3. Before insert trigger:

1. 
   afsonalar_kiritish_oldin triggerini yaratamiz.
   

14.12– rasm. afsonalar_kiritish_oldin triggerini yaratish so`rovi

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

14.13 – rasm. afsonalar_kiritish_oldin triggerni ishlashi natijasi
14.5. After insert trigger

14.5.1. afsonalar_kiritish_keyin triggerini yaratamiz.

14.17– rasm. afsonalar_kiritish_keyin triggerini yaratish so`rovi

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

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

1. 
   afsonalar_ochirish_oldin triggerini yaratamiz;
   

14.15 – rasm. afsonalar_ochirish_oldin triggerini yaratish

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

14.16 – rasm. afsonalar0 jadvalidan satr o`chirish natijasi


6. After delete trigger
6.1. afsonalar_ochirish_keyin triggerini yaratamiz;

14.17– rasm. Master_ochirish_keyin triggerini yaratish

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

14.18 – rasm. Master0 jadvalidan satr o`chirish natijasi