RE: CREATE TABLE and CHECK clausole

2002-12-03 Thread Victor Pendleton
ent: 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 trie

RE: CREATE TABLE and CHECK clausole

2002-12-03 Thread Jon Frisby
o: 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 &

Re: CREATE TABLE and CHECK clausole

2002-12-03 Thread R. Hannes Niedner
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 supp

re: CREATE TABLE and CHECK clausole

2002-12-03 Thread Egor Egorov
Achille, Tuesday, December 03, 2002, 11:08:19 AM, you wrote: AML> MySQL seems to support the CHECK() clausole in the implementation of CREATE AML> TABLE statement, but MySQL (Ver 11.15 Distrib 3.23.39, for pc-linux-gnu) AML> returns a syntax error on such a command. For example: AML> mysql> CREAT

Re: CREATE TABLE and CHECK clausole

2002-12-03 Thread R. Hannes Niedner
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 On 12/3/02 1:08 AM, "Achille M. Luongo" <[EMAIL PROTECTED]> wrote: > Dear subscribers, > > MySQL seems to support the CHECK() clausole in the implementation of CREATE > TABLE