• 17.11 – rasm.
    		•

    O'zbеkiston r




    Download 7,78 Mb.
    bet43/56
    Sana02.12.2023
    Hajmi7,78 Mb.
    #109653
    1   ...   39   40   41   42   43   44   45   46   ...   56
    Master_yangilash1 triggerini yaratamiz;



      1. – rasm. Master_yangilash triggerini yaratish

      1. Triggerni ishlatamiz; IDsi 3ga teng xodimning yoshiga 5 ni qo’shamiz;

    Eslatma: bu ma’lumotni yuqorida master0 jadvaliga ham ko’chirdik;


      1. – rasm. Trigger yaratilgan jadvalda Update operatorini qo’llash

      1. Master0 ni ko’ramiz;



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



      1. – 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.


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


      1. – 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.


    17.14 – rasm. Master_kiritish_keyin triggerining ishlash natijasi

    Download 7,78 Mb.
    1   ...   39   40   41   42   43   44   45   46   ...   56




    Download 7,78 Mb.