MySQL Forums
Forum List  »  Triggers

Duplicated values
Posted by: David Villalobos Cambronero
Date: June 27, 2006 09:08AM

Hi, I have a problem, I´m triying to insert values into a table, but there is a restriction, if some values are iqual the trigger has to show me an error.

I,ve triying to do this, but I can´t. Can someone helpme.

PD, attached an example:

INSERT INTO Curses VALUES ('Name', 'Second Name', 1, 1);

In this case I need a error mesage, because there are tow numbers 1.

Thanks.

David

Options: ReplyQuote


Subject
Views
Written By
Posted
Duplicated values
2658
June 27, 2006 09:08AM
1786
June 27, 2006 10:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.