• 17.13 – rasm. Master_kiritish_oldin
  • 17.14 – rasm. Master_kiritish_keyin
  • 17.16 – rasm. Master0
    		•

    Master0 ni ko’ramiz; rasm




    Download 1,88 Mb.
    bet6/9
    Sana19.12.2023
    Hajmi1,88 Mb.
    #124326
    1   2   3   4   5   6   7   8   9
    Bog'liq
    6-Amaliy mashg'ulot

    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
    5. Before delete trigger

      1. Master_ochirish_oldin triggerini yaratamiz;


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


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

    Download 1,88 Mb.
    1   2   3   4   5   6   7   8   9




    Download 1,88 Mb.