Toshkent axborot texnologiyalari universiteti

mysql> create trigger master_kiri tish_olchn

-Y before insert
-Y on mastero for each row begin

-> declare a varchar(50) ;

-> select user() into a; set new. FISH=a; end; //
Query OK, O rows affected (0.45 sec)
17.12 — rasm. triggerini yaratish so'rovi
I .2. Yaratgan triggerimizni ishlatamiz va natijasini master0 jadvalida ko'ramiz; ya'ni biz trigger yordamida yangi satr kiritdik.
nysql> insert into masterC values(l, 'Narzullayev SH ^I , 18, 'nzzax');
17.13 — rasm. Master kiritish_oldin triggerni islllashi natijasi

4. 
   After insert trigger
   
   1. 
      Master_kiritish_keyin triggerini yaratamiz.
      

17.14 — rasm. Master_kiritish_keyin triggerini yaralish so*rovi
1.2. Yaratgan triggerimizni ishlatamiz va natijasini master() jadvalida ko'ramiz; ya'ni biz tngger yordamida yana yangi satr kiritdik.
mysqil> Insert Into master0 values (5, 'xushmurodov—y' , 21, 'Qasnqacaryo');
17.14 — rasm. Master_kiritish_keyin triggerining ishlash natijasi

4. 
   Before delete trigger
   
   1. 
      Master ochir'ish_oldin triggerini yatatamiz;
      

15. 
    ochirish_oldin triggerini yaratish
    

5,2, Yaratgan triggerimizni ishlatamiz va natljasini masterO jadvalida ko'ramiz; ya'ni biz trigger yordamida ID 5 ga teng satrni o'chirdik.

15. 
    — rasm. MasterOjadvaIidan satr cc chirish natijasi
    

4. 
   After delete trigger
   
   1. 
      Master_ochirish_keyin triggerini yaratamiz;
      

snysql> del i miter // mysql> create trigger master—ochiri sh—keyin after delete on master for each row begin declare c varcharC50) ; select user () into c; insert into masterO
(i d FISH s del ete_yosh i s, de e oyi ) values Cold. id, old. FISH* old. turar_joyi); end; // uery OKs O rows affected CO. 07 sec)
17.17— rasm. triggerini yaratish
I .2. Yaratgan triggerimizni ishlatamiz va natijasini master0 jadvalida ko'ramiz; yani biz trigger yordamida ID I ga teng satrni ham o'chirdik.

17.18 — rasm. MasterO jadvalidan satr o'chirish natijasi

7. 
   drop trigger:
   

7.1. Oldingi misollarda yaratgan master_ochirish oldin triggerini o'chiramiz;

I , Yuqorida ko'rsatilganlardan foydalanib tanlangan variyantga muvofiq mavzu uchun MySQL da protseduralar yarating va undan foydalaning.
2.Bajarilgan ishlar haqida tayyorlang (l -2-ilovalarga qarang).
Nazorat savollari
l . Triggerni yaratish qanday amalga oshiriladi ?
2. Protseduralarni yaratish qanday amalga oshiriladi? 3 Protsedurani Chaqirish qanday amalga oshiriladi?
4, Delimiter belgisi nima uchun ishlanadi?