Re: Obtain primary key value generated by before-insert trigger

[Ross Goldberg]

The primary key column of my table is not auto_increment.

My before-insert trigger generates a primary key value, which then successfully writes to the table.

The problem is that my calling client must be able to retrieve that value, in a thread-safe manner.

I tried running your select after I performed an insert, but the select always returned null.