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
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
"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.
--