Re: A few questions on triggers in MySQL 5

[Jay Pipes]

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?

> 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
>