I can't use it....for example i have to create a column that accept values
between 1 to 120...i can't enumerate all of them....or i have to accept a
value different from NULL if an other column has a certain values, otherwise
the first must be NULL, it's impossible to use enum to do this!
----- Original Message -----
From: "Michael Brunson" <br*****@intercosmos.com>
To: "Alex82" <al*****@tin.it>
Cc: <my***@lists.mysql.com>
Sent: Tuesday, July 15, 2003 12:13 AM
Subject: Re: Fw: check
Use an ENUM()
On Mon, 14 Jul 2003 23:57:56 +0200, "Alex82"
<al*****@tin.it> wrote:
| so what can i do to make a column accetp only certain values...there are
any
| other solutions?
| ----- Original Message -----
| From: "Egor Egorov" <eg*********@ensita.net>
| To: <my***@lists.mysql.com>
| Sent: Monday, July 14, 2003 1:58 PM
| Subject: Re: check
|
|
| > "Alex82" <al*****@tin.it> wrote:
| > > i have a problem with the check option
| > > for example
| > > create table ex
| > > (
| > > t INT check(t<4)
| > > );
| > > but even if i use check(t<4) i can insert 5,6,7.....all values!:(
| > > why?
| > > Ale
| > > p.s. I'm using 4.0.12 version
| >
| > CHECK clause does nothing. It's just parsed.
| >
| >
| >
| > --
| > For technical support contracts, goto
https://order.mysql.com/?ref=ensita
| > This email is sponsored by Ensita.net http://www.ensita.net/
| > __ ___ ___ ____ __
| > / |/ /_ __/ __/ __ \/ / Egor Egorov
| > / /|_/ / // /\ \/ /_/ / /__ Eg*********@ensita.net
| > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
| > <___/ www.mysql.com
| >
| >
| >
| >
| > --
| > MySQL General Mailing List
| > For list archives: http://lists.mysql.com/mysql
| > To unsubscribe: http://lists.mysql.com/mysql?unsub=al*****@tin.it
| >
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=al*****@tin.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw