Martijn Tonies wrote:

> MySQL DOES have triggers and FK cascade, so there is an issue.
>

Yes and no. Foreign keys are implemented in the InnoDB storage engine
only. I can't say there is wide spread appreciation for the theoretical
issues involved.

> There REPLACE statement is documented as "delete and then insert".
>

Yes, my point. Any fields not referenced in the statement are lost and
delete and insertion triggers are fired. It isn't what I would call a
useful or pretty situation.

> No doubt, they couldn't care less and say that their replace is to
> documented
> to work as such, annoying as it is.
>
>

Be very careful about loose use of the word "they" with regard to
MySQL. I have it on very good authority that they have hired a number
of senior architects to figure out how to fix some of these problems.