Simple Table Triggers Question

[LucL]

Hey Guys,

How do I create a new trigger for a table that already exists and has data in it?

I'm guessing this is not the same as "stored procedures/functions" because the triggers are related to each table.

I'm using mysqladministrator and query editor but don't see a trigger editing feature.

Thanks,
Luc L.

 

[LucL]

N/M Figured it out for myself. CREATE TRIGGER command

 

[johnwm]

Have you checked out the MySQL docs?

http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints