MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

Re: create constraints
Posted by: Andrew Gilfrin
Date: March 30, 2005 01:55AM

I'd be carefull when using the NOT NULL constraint as it doesn't function in the same way as Oracle. You can checkout a couple of tip's I wrote on the subject here.

http://www.quest-pipelines.com/pipelines/mysql/tips04.htm#december
http://www.quest-pipelines.com/pipelines/mysql/tips.htm#february

Also I'm currently looking at the suitability of triggers to implement simple check constraints. There are a number of issues with it such as MySQL Triggers inability to use SQL against tables and also the lack of a raise statement.

Check the documentation or my site http://www.mysqldevelopment.com for more info on triggers.

Andrew Gilfrin
http://www.mysqldevelopment.com

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


Subject
Views
Written By
Posted
create constraints
17283
b sollie
March 05, 2005 03:05AM
Re: create constraints
4255
Josh Chamas
March 17, 2005 01:25AM
Re: create constraints
3934
Andrew Gilfrin
March 30, 2005 01:55AM
Re: create constraints
3168
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.