Using a trigger to ensure uniqueness (4 replies)

Hello,

I want to ensure that rows inserted into a database table are unique based upon a set of keys (more than the 16 allowed by my version of mysql for PKs).

I am new to triggers and do not know how to implement a trigger that would perform such a check.

Can anyone please help? Code samples or links welcome.

Thanks in advance,

Julien.