[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