Mavzu: sql tilida index yaratish Ish

Master0 ni ko’ramiz;

8. 
   rasm. Update operatorini ishlatilganidan keyin master0 jadvalidagi ma’lumotlarning o’zgarishi
   

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

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

1. 
   master_kiritish_oldin triggerini yaratamiz.
   

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.
   

17.13 – rasm. Master_kiritish_oldin triggerni ishlashi natijasi
4. After insert trigger
4.1. Master_kiritish_keyin triggerini yaratamiz.

14. 
    – rasm. Master_kiritish_keyin triggerini yaratish so`rovi
    

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

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

1. 
   Master_ochirish_oldin triggerini yaratamiz;
   

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

17.16 – rasm. Master0 jadvalidan satr o`chirish natijasi
6. After delete trigger