-
Zdrasduviyci Masteri.
U mina yes view katoruy svyazivayit neskolka table .
Mina nujun shto kakda udalu iz view rabotal moy
INSTEAD OF TRIGGER.
Ya sazdal trigger na view no on ni rabotayit.patamushta
Ado ni udalit stroka iz view a udalit iz table.
naprimer
create view my_view
as
select * from table1 innser join table2 on <>
inner join table3 on <>
kakda Ado udalit stroku
on atpiravlayit serveru
Delte from table1 where <>
Delete from table2 where <>
Delete from table where <>
i patamu moy trigger ni rabotayit patamusta on rabotal kakda yesli
ado atpravil
Delete from my_view where <>
Vapros takoy kak zdelit shto Ado udalil iz view.