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 dev.mysql.org. You know the correct definition better than me.

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

Thanks
Martin

Options: ReplyQuote


Subject
Views
Written By
Posted
2342
November 29, 2013 07:01AM
1186
November 29, 2013 12:27PM
1154
November 29, 2013 02:21PM
1123
November 30, 2013 04:03PM
1195
November 30, 2013 11:37PM
Re: trigger with condition
1058
December 01, 2013 03:52AM
1043
December 01, 2013 01:46PM
1088
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.