I don't understand your question
-Original Message-
From: Sukhdev Sethi [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 7:20 AM
To: [EMAIL PROTECTED]
Subject: querying check constraints
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_incr
Hi,
I have created a table as below:
create table myTable
(
Field1 int auto_increment not null,
Field2 varchar(25) not null,
Field2 enum('Fair','Good','Excellent'),
primary key (Field1))
auto_increment=1
I would like to know how to query the table for only
the enum values I have
Neil,
Thursday, February 21, 2002, 12:18:27 AM, you wrote:
NZ> Hello,
NZ> I searched the manual but it seems like MySQL does not support ANSI SQL
NZ> CHECK constraints. These are often used to check that rows inserted into
NZ> tables meet specified criteria. For example table
Hello,
I searched the manual but it seems like MySQL does not support ANSI SQL
CHECK constraints. These are often used to check that rows inserted into
tables meet specified criteria. For example table T created as follows
CREATE TABLE T (
X INT,
CHECK (X <= 10)
);
has a check constra
