Re: trigger with condition

[Martin Tomczyk]

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