Talk:Triggers
The check constraint emulation uses a 'BEFORE INSERT' trigger. If the check constraint involves an auto_increment column, the 'NEW.' value is not available. For InnoDB tables, a solution is to switch to an 'AFTER INSERT' trigger, because the failure will roll back the insert. Any solutions for MyISAM? --Snoyes 16:41, 10 July 2006 (CEST)