" <[EMAIL PROTECTED]>
Sent: Wednesday, 04 June, 2003 18:54
Subject: Re: MySQL: standard SQL compliancy: primary keys: default: should be
NOT NULL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Becoming Digital wrote:
[snip]
> from http://www.mysql.com/doc/en/CREATE_TABLE.html:
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Becoming Digital wrote:
[snip]
> from http://www.mysql.com/doc/en/CREATE_TABLE.html:
> a.. A PRIMARY KEY is a unique KEY where all key columns must be
defined as NOT
> NULL. If they are not explicitly declared as NOT NULL, it will be done
> implicitly
Hi,
We agree that statements of the form
CREATE TABLE table-name (column1 INT PRIMARY KEY)
should be legal -- it should not be necessary to say
CREATE TABLE table-name (column1 INT PRIMARY KEY NOT NULL)
The requirement, that primary keys should explicitly be
declared as NOT NULL
iginal Message -
From: "Neil Zanella" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, 04 June, 2003 01:03
Subject: MySQL: standard SQL compliancy: primary keys: default: should be NOT
NULL
Hello,
I believe that MySQL is in erro
Hi Neil.
On Wed, Jun 04, 2003 at 02:33:22AM -0230, Neil Zanella wrote:
> I believe that MySQL is in error in reporting the following message just
> because I did not specify that the PRIMARY KEY should not be NULL. These
> days there are standards and SQL92, AFAIK, specifies that if the primary
>
Daniel Kasak wrote:
Neil Zanella wrote:
SQL92, AFAIK, specifies that if the primary
key is not explicitly set to NOT NULL then the RDBMS should
automatically
and silently assume the user means NOT NULL.
Sounds like the end of the world to me ;)
I suppose you have to get excited about something..
, June 04, 2003 12:03 AM
Subject: MySQL: standard SQL compliancy: primary keys: default: should be
NOT NULL
Hello,
I believe that MySQL is in error in reporting the following message just
because I did not specify that the PRIMARY KEY should not be NULL. These
days there are standards and
Neil Zanella wrote:
Hello,
I believe that MySQL is in error in reporting the following message just
because I did not specify that the PRIMARY KEY should not be NULL. These
days there are standards and SQL92, AFAIK, specifies that if the primary
key is not explicitly set to NOT NULL then the RDBM
Hello,
I believe that MySQL is in error in reporting the following message just
because I did not specify that the PRIMARY KEY should not be NULL. These
days there are standards and SQL92, AFAIK, specifies that if the primary
key is not explicitly set to NOT NULL then the RDBMS should automatical
