MySQL Forums
Forum List  »  Newbie

Creating and enforcing integrity constraints
Posted by: Khawer Khaliq
Date: March 08, 2008 01:46PM

I am a new user of MySQL Community Edition. How can table and database level integrity constraints be added and enforced in MySQL? It appears the CREATE ASSERTION statement does not work in MySQL. So is there no way to create general database level constraints? For table-level constraints, there is a CHECK clause in the CREATE TABLE statement, but I am told it is not enforced. Can this behavaiour be changed? Would appreciate any assistance.

Options: ReplyQuote


Subject
Written By
Posted
Creating and enforcing integrity constraints
March 08, 2008 01:46PM


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.