[Phpwm] MySQL triggers, creating hashed id

pete graham petegraham1 at gmail.com
Fri Aug 17 17:51:07 BST 2007


> Just a thought, does LAST_INSERT_ID() work in the trigger context? Could
> you use that in an AFTER trigger?

I'm not sure if LAST_INSERT_ID() will work but you still have the
problem that it appears you can't update values in the table
causing/calling the trigger from the AFTER trigger (see comments here
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html).

I think I will have to insert then have a update query, how inelegant ;-(



More information about the Phpwm mailing list