Raiserror in MySql

[Jim Daly]

Hello,

in MS SqlServer, I can write a trigger that joins a series of tables and raise an error for a specific condition.

I've glanced through the MySql documents, but haven't found an equiland to MsSql's RAISERROR.

Essentially, how would I throw an exception from inside a trigger in MySql? Preferably, I don't want to use an external function to raise the error, as the MySql engine could potentially be ported to various platforms.

Thank you in advance.

Cheers,

Jim