RE: Second Request - Limit Filed Input

2001-03-22 Thread Sinisa Milivojevic
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

RE: Second Request - Limit Filed Input

2001-03-21 Thread Shankar Unni
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

RE: Second Request - Limit Filed Input

2001-03-20 Thread Ravi Raman
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:

RE: Second Request - Limit Filed Input

2001-03-20 Thread Cal Evans
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

RE: Second Request - Limit Filed Input

2001-03-20 Thread Bill Marrs
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

RE: Second Request - Limit Filed Input

2001-03-20 Thread Ravi Raman
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,

RE: Second Request - Limit Filed Input

2001-03-20 Thread Bill Marrs
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