Re: Create trigger for more than one table
Posted by:
Bob Field
Date: October 04, 2006 10:47AM
Best I can suggest is to write something like a PHP script that would query the information_schema.columns view to find columns named UPDATED_DATE and either create the trigger directly, or output a SQL script to create the triggers which is then piped into the mysql command-line utility.
Subject
Views
Written By
Posted
4731
October 04, 2006 08:55AM
Re: Create trigger for more than one table
2017
October 04, 2006 10:47AM
2367
October 16, 2006 06:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.