On 11/17/05, Jay Pipes <jay@stripped> wrote:
>
> Jenny Chen wrote:
> > Hi,
> >
> > Does the current latest MySQL 5.0 support:
> > 1. column based triggers
>
> No, not currently. Only full FOR EACH ROW based triggers.
>
> > 2. trigger restriction
>
> Could you be a little more specific on this?
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?
> 3. multiple triggers of same type of the table
>
> Kind of. You can have multiple triggers (BEFORE UPDATE & AFTER UPDATE or
> AFTER
> INSERT & BEFORE UPDATE). But not two triggers of the same timing and
> event,
> i.e. you can't have two AFTER INSERT triggers on the same table.
>
> > 4. triggers reference another table
>
> Yes, since 5.0.10
>
> >
> > And any information on in which release they will be supported?
> >
> >
> > Thanks,
> > Jenny
> >
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe: http://lists.mysql.com/internals?unsub=1
>
>
