MySQL Forums
Forum List  »  Newbie

How to define a constraint with CURR_DATE()
Posted by: Hernando Duque
Date: March 30, 2005 06:37AM

Hi,

I want to define a constraint for assigning CURDATE() to a field but it should works just once when the record is inserted. I've tried something like this:

ALTER my_table ALTER my_field SET DEFAULT CURDATE();

But it seems that it is not the right way. Any help will be appreciated.

Nando.

Options: ReplyQuote


Subject
Written By
Posted
How to define a constraint with CURR_DATE()
March 30, 2005 06:37AM


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.