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

In response to

• Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page at 1998-03-18 08:09:44 from Luuk de Boer

pgsql-hackers by date

Next:	From: PostgreSQL On Peanuts.roanoke.edu	Date: 1998-03-19 01:04:49
	Subject: regression testing on linux-elf 2.0.33, postgresql 6.3, i686
Previous:	From: David Gould	Date: 1998-03-18 23:51:51
	Subject: Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6