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
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.com
-Original Message-
From: [EMAIL PROTECTED] [mai
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:
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
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 the
neous 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/2001 -0500,
rror-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 12:48 PM
To: [EMAIL PROTECTED]
Subject: RE: Second Request - Limit F