Dennis,
Innobase (= InnoDB starting from version 3.23.37) allows you to have
an index on a column which may contain nulls. However, the ANSI SQL
specification requires that the columns in a primary key are declared
as not null. If your main key may can contain nulls, do not define
a primary key at all, only an ordinary index. Example:
CREATE TABLE D1 (A INT, B INT, INDEX (A)) TYPE = INNOBASE;
Regards,
Heikki
>>>>> "DG" == Dennis Gearon <[EMAIL PROTECTED]> writes:
DG> Is it true no indexing on Nulls In the Innobase database tables and
DG> MyIASMDG> tables?
>Dunnow about Innobase tables, but MyISAM tables let you have indexes
>on nullable columns. ISAM did not.--
---------------------------------------------------------------------
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
