Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page

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