`supermarket`


Download 0.66 Mb.
bet7/7
Sana25.11.2020
Hajmi0.66 Mb.
#151524
1   2   3   4   5   6   7
Bog'liq
Murod

6.


CREATE TRIGGER Update_triger

AFTER UPDATE on talaba

FOR EACH ROW

INSERT INTO amallar



SET id = NULL, talaba.id = new.id , amal_nomi='update', vaqti = NOW()



UPDATE talaba SET talaba.`F.I.Sh` = 'Jumayev alisher', talaba.guruh_name'21819' WHERE talaba.id = 5


Download 0.66 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6   7




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling