You are correct. The 'CHECK` clause does not do anything. The syntax is provided only for compatibility and to aid in porting code from other DBMSs.
-----Original Message----- From: Jon Frisby [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 12:43 PM To: 'MySQL Mailinglist' Subject: RE: CREATE TABLE and CHECK clausole I've attempted to get the CHECK clause to work as well, and have had no luck. I don't think it's actually supported by MySQL yet. -JF > -----Original Message----- > From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 7:42 AM > To: Achille M. Luongo; MySQL Mailinglist > Subject: Re: CREATE TABLE and CHECK clausole > > > On 12/3/02 4:32 AM, "Achille M. Luongo" > <[EMAIL PROTECTED]> wrote: > > > Dear Sir, > > > > I have tried with FLOAT or DECIMAL data types, but MySQL > always returns the > > same error. After your suggestion, I double checked the > MySQL data types > > definition list and the INTEGER (alias INT) data type is supported. > > > > Thanks in advance for any other suggestion. > > > > Achille. > > > > "R. Hannes Niedner" wrote: > >> > >> Maybe it's just to late for me to think clearly but there > are NO INTEGERS > >> between 0 and 1, try FLOAT or DECIMAL. > >> > >> Best/h > > You are certainly correct, I tried all kinds of expressions > and datatypes > and couldn't get it to work, but my point was rather that there are no > INTEGERs between 0 and 1. In any case the manual entry is > very slim for the > CHECK clause in the CREATE TABLE statement, and somebody > already asked for > and example. Where are the experts on this list? > > /h > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
