Hi,
But the problem is that mysql is not accepting the syntax, not that it will
do nothing with it.
Quentin
-----Original Message-----
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 12:40
To: SF
Cc: [EMAIL PROTECTED]
Subject: Re: CHECK variable incorrect?
In the last episode (Feb 07), SF said:
> I did, and that's where I don't understand why this is happening.
> The furthest I was able to get in the manual and/or any of the
> archives from MySQL is:
>
> (straight out of the manual)
> CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[(create_definition,...)]
> [table_options] [select_statement]
>
> create_definition:
> col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
> [PRIMARY KEY] [reference_definition]
> or PRIMARY KEY (index_col_name,...)
> or KEY [index_name] (index_col_name,...)
> or INDEX [index_name] (index_col_name,...)
> or UNIQUE [INDEX] [index_name] (index_col_name,...)
> or FULLTEXT [INDEX] [index_name] (index_col_name,...)
> or [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...)
> [reference_definition]
> or CHECK (expr)
>
> ^^^^^^^^^^^^
> ||||||||||||
>
> The comment that CHECK (expr) is supposed to be written as such, is
> something that I either don't understand - and if so, what is wrong with
it
> in the string I am using (line 4: "CHECK (rank IN (1,2,3))")? - or an
error
> I don't understand is causing this - that's why I'm asking.
Look farther down in the manual:
* The `FOREIGN KEY', `CHECK', and `REFERENCES' clauses don't
actually do anything. The syntax for them is provided only for
compatibility, to make it easier to port code from other SQL
servers and to run applications that create tables with references.
*Note Missing functions::.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
