Shankar Unni writes:
> I don't see implementation of "CHECK" CONSTRAINTS in the TODO list (e.g.
>
> CONSTRAINT val_ck check (val >= 0 and val <=5)
>
> Is this planned?
>
> I do see FOREIGN KEY constraints on the 4.0 list, so there is a way to do
> this kind of checking once this is
ev(state),
...
);
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:27 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Second Request - Limit Filed Input
you can use either an ENUM or a SET. Other than that, no.
Cal
http://www.calevans.
tor to do some
>sort of error-check or update/delete all erroneous rows, or whatever you
>decide to do.
>...in other words, it's a feature, not a bug.
>
>-ravi.
>
>-Original Message-
>From: Bill Marrs [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, March 20, 2001
oneous rows, or whatever you
decide to do.
...in other words, it's a feature, not a bug.
-ravi.
-Original Message-
From: Bill Marrs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:48 PM
To: [EMAIL PROTECTED]
Subject: RE: Second Request - Limit Filed Input
At 11:22 AM 3/20/20
At 11:22 AM 3/20/2001 -0500, Ravi Raman wrote:
>You can use an ENUM column type assuming the numerical range is less than
>65535 numbers.
>
>http://www.mysql.com/doc/E/N/ENUM.html
One problem I've seen with enums is that I end up with a blank ('') field
if I try to insert a row with a value in t
you can use either an ENUM or a SET. Other than that, no.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 10:05 AM
To: [EMAIL PROTECTED]
Subject: Second Request - Limit Filed Input
Is there a way in MySQL
Hi.
You can use an ENUM column type assuming the numerical range is less than
65535 numbers.
http://www.mysql.com/doc/E/N/ENUM.html
-ravi.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 11:05 AM
To: [EMAIL PROTECTED]
Subject: Second