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
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.

RE: Second Request - Limit Filed Input

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

RE: Second Request - Limit Filed Input

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

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 t

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 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: Second