directxBOB
asked on
MYSQL Constraint Check
I've been trying to get the CHECK working in MYSQL and from what I am reading it's not yet been implemented.
How would I go about getting this to work:
ALTER TABLE contracts
ADD CONSTRAINT contract_check CHECK (value >500 )
How would I go about getting this to work:
ALTER TABLE contracts
ADD CONSTRAINT contract_check CHECK (value >500 )
As you have allready read, it is not implemented, alas, you can not get it to work.
ASKER
is there any form of work around? Perhaps a trigger mechanism.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.