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 a
> "DG" == Dennis Gearon <[EMAIL PROTECTED]> writes:
DG> Is it true no indexing on Nulls In the Innobase database tables and
DG> MyIASM
DG> tables?
Dunnow about Innobase tables, but MyISAM tables let you have indexes
on nullable columns. ISAM did not.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Is it true no indexing on Nulls In the Innobase database tables and
MyIASM
tables?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
