Re: Problems with ALTER TABLE
Posted by:
Bob Field
Date: March 21, 2006 12:55PM
Try something like this to constrain the sex field:
create table example
sex enum('M','W'),
n1 int(9),
);
Why 4.1 and not 5.0? In 5.0 you can write a trigger that will keep your numeric field in the appropriate range.
Subject
Views
Written By
Posted
3342
March 21, 2006 11:51AM
2093
March 21, 2006 11:56AM
2483
March 21, 2006 12:29PM
Re: Problems with ALTER TABLE
2105
March 21, 2006 12:55PM
2058
March 21, 2006 01:07PM
1971
March 21, 2006 01:15PM
1972
March 21, 2006 01:28PM
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.