Hi,
I want to create an trigger in SQL
I have the but of creating a trigger
Java Code:
create trigger stockinsert
after insert on Test_items

end
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 table

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.