Re: trigger with condition
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
Subject
Views
Written By
Posted
2849
November 29, 2013 07:01AM
1438
November 29, 2013 12:27PM
1498
November 29, 2013 02:21PM
1390
November 30, 2013 04:03PM
1406
November 30, 2013 11:37PM
Re: trigger with condition
1348
December 01, 2013 03:52AM
1343
December 01, 2013 01:46PM
1365
December 01, 2013 03:21PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.