MySQL Forums
Forum List  »  Triggers

Re: trigger with condition
Posted by: Martin Tomczyk
Date: December 01, 2013 03:52AM

Hi Peter,

I thought that you are going to say that and I agree that this is not the ideal way of using triggers (or maybe even a mis-use). The thing is that this is the most simple way to achieve it. Behind those two db's are individual CMS systems. The only other way I can currently think of would be to write an CMS extension to do this. this would involve user credentials and setting permissions that each CMS should not have over the other. Or a periodical import/export (also not ideal)
or a cronjob that would run a query prediodically (also bad).
I wanted to avoid those options.

Regarding the wording of "extension of trigger" I only quoted ont-to-one the refman under You know the correct definition better than me.

But if you look at the it ok like that? Even though it works it might be improved.


Options: ReplyQuote

Written By
November 29, 2013 07:01AM
November 29, 2013 12:27PM
November 29, 2013 02:21PM
November 30, 2013 04:03PM
November 30, 2013 11:37PM
Re: trigger with condition
December 01, 2013 03:52AM
December 01, 2013 01:46PM
December 01, 2013 03:21PM

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.