Re: LAST_INSERT_ID() question.

[Roland Bouman]

I'm a bit confused, because you say: "In an after *update* trigger I write..If I *insert* a new record into A".

Is this really the case (update trigger gets fired for insert event?)?

last_insert_id() returns the last id that was handed out to an auto_increment column within your session. So, if you'd have an after INSERT trigger, and INSERT from within your trigger, and then reference last_insert_id(), you'd get the value of the id of the record you inserted in the trigger; not the id of the record that was inserted prior to firing the trigger.