MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

Re: create constraints
Posted by: Josh Chamas
Date: March 17, 2005 01:25AM

b sollie wrote:
> can someone help my with the constraints in this
> script? i'am using mysql server 4.1 and i'am
> trying to insert these tables and constraints into
> my mysql schema. can anyone give me advice?
>

MySQL does not currently support constraints like many of these defined.
The NOT NULL ones we support, as well as the REFERENCES (with InnoDB).
However things like the CHECK constraints we do not have, and you might
consider using triggers in 5.0.x release to implement this functionality.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
create constraints
17276
b sollie
March 05, 2005 03:05AM
Re: create constraints
4250
Josh Chamas
March 17, 2005 01:25AM
Re: create constraints
3930
Andrew Gilfrin
March 30, 2005 01:55AM
Re: create constraints
3164
Renato Marroquin
April 15, 2008 11:27PM


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.