On Wednesday 05 July 2006 11:40 am, Jay Blanchard wrote: > [snip] > Say I have two regular tables (table1, table2) and what a column > (status) in > the second table to update when it changes in table1. For example, if I > set > the status for a user in table1 to "0", the status for all that user's > records in table2 dynamically changes to "0". > > Can this be done? What method is used? > [/snip] > > http://www.mysql.com/trigger
Why not a foreign key constraint in this case? Granted it would be something like ON DELETE SET NULL, and you'd have to verify that the columns were not NOT NULL, but the application logic should remain the same with regards to that. -- Chris White PHP Programmer Interfuel 805.642.2200 x110 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
