• 17.16 – rasm. Master0
  • 17.18 – rasm. Master0
  • 18 - LA B O R A T O R IYA I S H I
    		•

    O'zbеkiston r




    Download 7,78 Mb.
    bet44/56
    Sana02.12.2023
    Hajmi7,78 Mb.
    #109653
    1   ...   40   41   42   43   44   45   46   47   ...   56
    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
    6.1. Master_ochirish_keyin triggerini yaratamiz;


      1. – rasm. Master_ochirish_keyin triggerini yaratish

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


    17.18 – rasm. Master0 jadvalidan satr o`chirish natijasi
    7. drop trigger:
    7.1. Oldingi misollarda yaratgan master_ochirish_oldin triggerini o’chiramiz;


      1. – rasm. Ma’lumotlar bazasidagi triggerni o’chirish

    Vazifalar
    1.Yuqorida ko`rsatilganlardan foydalanib tanlangan variyantga muvofiq mavzu uchun MySQL da protseduralar yarating va undan foydalaning.
    2.Bajarilgan ishlar haqida hisobot tayyorlang (1-2-ilovalarga qarang).


    Nazorat savollari

    1. Triggerni yaratish qanday amalga oshiriladi ?

    2. Protseduralarni yaratish qanday amalga oshiriladi?

    3. Protsedurani chaqirish qanday amalga oshiriladi?

    4. Delimiter belgisi nima uchun ishlanadi?


    18 - LABORATORIYA ISHI

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




    Download 7,78 Mb.