MySQL Forums
Forum List  »  Docs

constraint for a column only
Posted by: Katja Fink
Date: July 01, 2010 08:29AM

Dear all,

When designing a database it would be so helpful to avoid false data being typed in the database table. Sometimes a constraint helps to make sure to write into one table first before in another.

Now I was looking for something that I would call colument constraint - which I thought I could find a solution by creating a trigger. Aim is to make sure that no nonsense data - for example for dates would be not accepted by "apply changes" when a date is greater than f.e. sysdate.

Or is there a way to get a description message ... ???

Again I am lucky if someone has an idea - or the mySQL developer team understands the problem I have ...

Greetings from Germany, Cathy

Options: ReplyQuote


Subject
Views
Written By
Posted
constraint for a column only
4287
July 01, 2010 08: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.