MySQL Forums
Forum List  »  Triggers

Re: Trap illegal date in trigger
Posted by: Peter Brawley
Date: April 06, 2015 03:41AM

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

Options: ReplyQuote


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.