Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

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 key

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

[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 error in reporting the following message just because I did not specify

MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

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

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: 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

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

: 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: a.. A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL

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 SQL92, AFAIK, specifies that if the primary key is not explicitly set to NOT NULL then the RDBMS should

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

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

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

, 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

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

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