Re: Enforce business rule with before insert trigger?

[Roland Bouman]

mmm, nasty.

I understand the requirement, but its not that easy. There are two main problems:

1) you want to process a whole bunch of rows after they've all been inserted. So, you;d need a trigger for the entire insert statement. That is currently not supported. MySQL currently only supports triggers for each row - not a statement as a whole.

2) You dont really want to rollback, at least not silently. How would you know the operation failed? What you really want to do is raise an error, which will prevent the transaction from being comitted. Now, raising an error is currently not supported.

I'm thinking this over. If someone has a good solution, I'll be reading that, eager to learn as I am. But I will get back on this.

good luck!