Trigger after insert: get the ID of the inserted column
648405Jul 5 2008 — edited Jul 5 2008Hi all!
Can I set up a trigger, that is fired immediately after I inserted a column into a table, and do something with the resulting primary key value?
It's an auto incement field, and I want to register that value in another table.
e.g.
- insert a row
- fetch the resulting primary key
- insert another row anywhere else via trigger
regards, Alex