User Profile

kate s · Dec 5 '08, 10:49 AM

Hi Atli, I cam up with the following code:

Code:

DELIMITER //

CREATE TRIGGER employee_tg 
BEFORE INSERT ON employee
FOR EACH ROW

BEGIN


IF new.employee_id = employee_id
AND new.place = place
THEN
SET @messsage = 'duplicate employee_id and place';

ELSEIF new.employee_id = new.employee_id
AND new.place = new.place
THEN

...

kate s · Dec 5 '08, 07:06 AM

Thank you for your assistance!

The way you created the UniqueTest table and inserted the values and MYSQL complained with an error is exactly what I need!! But I want this using a Trigger.

I still have problems in the code I provided in post#1. I fixed the errors you stated but it still complains with an error.

Do you know of how to create the trigger after the 'IF' statement and assign the error messages...

kate s · Dec 4 '08, 12:09 PM

Hi, I was researching through google and I found the RAISEERROR function to display the error message. I thought it will work for MYSQL. How can I display the error message then?

I have an employee table with employee_id and place fields. The trigger is activated by the Before Insert event.

The purpose of my trigger is prevent duplication in my table. When there's a duplication of employee_id and place the trigger generates...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Trigger for preventing duplicates.

Read from TXT file - Please Help