Re: LAST_INSERT_ID ia a AFRTER INSERT trigger

[Hans Verdel]

Thanks Peter.

I had already tested this. I would like to know at what point last_insert_id() does return a value. The trigger body apparently isn't.


I did some more testing. The proper way is to use NEW.id.
It returns the correct value, whether inserted as a NULL, 0 (zero) or an INT value.
It returns the correct value when left out of the INSERT statement.
It returns the correct value for each seperate row when inserting multiple rows through an INSERT ... SELECT ... statement.


Hope this helps others.