Re: Fw: check

[Mikael Engdahl]

Use InnoDB tables and a foreign key.

Alex82 wrote:

so what can i do to make a column accetp only certain values...there are any
other solutions?
----- Original Message -----
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 1:58 PM
Subject: Re: check
 

"Alex82" <[EMAIL PROTECTED]> 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
/ /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]
   



 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]