List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 9 2000 9:04pm
Subject:Re: RV: why can't create index
View as plain text  
>*** 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
Thread
RV: why can't create indexFernando Gonzalez Villarreal9 Feb
  • Re: RV: why can't create indexPaul DuBois10 Feb