-----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 (and quietly). In MySQL the key is named PRIMARY. A table can have > only one PRIMARY KEY. If you don't have a PRIMARY KEY and some applications ask > for the PRIMARY KEY in your tables, MySQL will return the first UNIQUE key, > which doesn't have any NULL columns, as the PRIMARY KEY. > a.. A PRIMARY KEY can be a multiple-column index. However, you cannot create a > multiple-column index using the PRIMARY KEY key attibute in a column > specification. Doing so will mark only that single column as primary. You must > use the PRIMARY KEY(index_col_name, ...) syntax. > > Long story short, regardless of whether or not MySQL complies with SQL92 specs, > it currently doesn't even comply with it's own documentation. That, I will > concur, is a problem. You have to remember that the manual is kept in sync with the _latest_ version of the server ... This change happened in 4.0.13 (implictly and quietly) :) -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+3niPtvXNTca6JD8RAuMfAJ4txHl4x2K+APxe+r1OOjeCs5wltwCfY6vs 6gZHm1VdNwPDIig38PdvdVA= =l2aO -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]