开发者

Does MySQL support check constraint? [duplicate]

This question already has answers here: CHECK constraint in MySQL is not working (8 answers) Closed 3 years ago.

Does MySQL support check constraint?

I am able to execute the following script in MySQL without error.

ALTER TABLE  EMP_DB_DESIGN_EXCEL  ADD (
   CONSTRAINT CHK_EMP_IS_ACTIVE CHECK (IS_ACTIVE IN ('Y','N')));

But it is not reflect开发者_如何学编程ed if I query:

 SELECT * FROM information_schema.TABLE_CONSTRAINTS T where t.table_name='EMP_DB_DESIGN_EXCEL';


So far as I can tell from past usage and the manual, MySQL only supports PRIMARY KEY, UNIQUE and FOREIGN KEY constraints, and these only if the table is an InnoDB table. Other storage types accept these constraints and store them after a fashion but do not enforce them. The kind of constraint you mention is not enforced; there appears to be some discussion on the MySQL website about it.


It is really frustrating not being able to enforce rules you want on your tables, rows and columns. The numbers of Engines for tables also doesn't make things easier. CHECK, TRANSACTION, FULLTEXT INDEX, FOREIGN KEY etc missing in some engines and present in some engines

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜