> Jenny Chen wrote:
>
> Like in Oracle, a trigger has three basic parts: trigger
> event/statement,trigger action, and trigger restriction( specifies a Boolean
> (logical) expression that must be TRUE for the trigger to fire. The trigger
> action is not executed if the trigger restriction evaluates to FALSE or
> UNKNOWN.) Does MySQL support it?
No, not currently. Perhaps one of the developers might comment on any future
plans to include this type of CHECK CONSTRAINT functionality for triggers...
Cheers.
