Re: Trap illegal date in trigger
> ms int date columns don't even have the same name across tables
Then write a func in the relevant app language, or a mysql user-defined function, to massage the values for the specific table names & columns.
> I'd hoped I'd be able to create a single trigger that could be used with each target mysql table.
Not possible, read the manual page on Triggers.
Subject
Views
Written By
Posted
2566
April 04, 2015 01:31AM
988
April 04, 2015 10:22AM
1071
April 06, 2015 03:14AM
Re: Trap illegal date in trigger
1159
April 06, 2015 03:41AM
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.