Dear subscribers,
MySQL seems to support the CHECK() clausole in the implementation of CREATE
TABLE statement, but MySQL (Ver 11.15 Distrib 3.23.39, for pc-linux-gnu)
returns a syntax error on such a command. For example:
mysql CREATE TABLE example (var INTEGER, CHECK(var BETWEEN 0 AND 1));
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
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 CREATE
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.
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
: 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