Horton

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

Michal Mosiewicz <mimo@interdata.com.pl>

View thread View on postgr.es
From: Michal Mosiewicz <mimo@interdata.com.pl>
To: Luuk de Boer <luuk_de_boer@pi.net>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>, lockhart@alumni.caltech.edu, hackers@postgreSQL.org
Date: 1998-03-19T00:05:53Z
Lists: pgsql-hackers 
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