I want to create an trigger in SQL
I have the but of creating a trigger
what i want to is when a insert happen on this table i want to find the attribute id of the tuple just added as use it to insert a tuble in another tableCode:
create trigger stockinsert
after insert on Test_items
so i understand i would be something like
insert into (tables name) (id attrubite i dont know how to get) then (value1, value2, value3)
Any help would be very appricated thank you.