>*** well i was unsure about if this message was sent so here is again,
>please excuse any inconvenience
> why can't create index with not null columns?
> you know:
> create table test (x int);
> create index xIdx on test (x);
> ERROR: 1121: columns 'x' is used with UNIQUE or INDEX but is not defined as
> NOT NULL
> i can do this is MS SQL but MySQL is faster so i'd use MySQL but i can't
> create that index with a not null field...
> why do i want this index?, easy i want to count multiple columns in one
> select statement and i need null columns so count function could count al
> not null values
> any idea???
You can do this in MySQL 3.23. Indexes are allowed to contain NULL.
Paul DuBois, paul@stripped