Re: problem with using CONSTRAINT declaration

2006-01-20 Thread Gleb Paharenko
Hello. MySQL doesn't support this yet. The CHECK clause is parsed but ignored by all storage engines. Ferindo Middleton Jr wrote: > I have the following table where I have a CHECK CONSTRAINT to check for > logical data values but for some reason it's not working on INSERTs to > the table. MySQL

problem with using CONSTRAINT declaration

2006-01-19 Thread Ferindo Middleton Jr
I have the following table where I have a CHECK CONSTRAINT to check for logical data values but for some reason it's not working on INSERTs to the table. MySQL doesn't give any error message when I CREATE TABLE. Any ideas what I'm doing wrong?... or Is this type of declaration not supported...