>
> 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. It's accepting
> create index statements but it isn't doing anything with it so that's
> why it's ignored.
So you can only have one index on a table? Yikes.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)