Luuk de Boer wrote:
>
> On 17 Mar 98 at 20:13, Bruce Momjian wrote:
>
> > What does it mean when MySQL says "Ignored" in the CREATE INDEX entry?
> >
>
> mysql isn't supporting create index like the ansi sql way. You must
> create an index in the create of the table with mysql.
Not necesarrily. You may use ALTER TABLE to ADD, REMOVE, CHANGE
KEY(s)/INDEX(es).
Mike
--
WWW: http://www.lodz.pdi.net/~mimo tel: Int. Acc. Code + 48 42 148340
add: Michal Mosiewicz * Bugaj 66 m.54 * 95-200 Pabianice * POLAND