Hi!
-Original Message-
From: "j.random.programmer" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Date: Saturday, March 02, 2002 5:21 AM
Subject: Re: Innodb tables lose foreign keys after creating an index...
>
>--- Heikki Tuuri <[EMAIL PROTECTED]> w
--- Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> Rick,
>
> sorry, it is not mentioned in the manual that MySQL
> performs a CREATE INDEX
> by doing an ALTER TABLE. And ALTER TABLE has the
> feature (= documented bug)
> that it removes foreign key definitions.
Heikki:
Is there a fix planned for th
Rick,
sorry, it is not mentioned in the manual that MySQL performs a CREATE INDEX
by doing an ALTER TABLE. And ALTER TABLE has the feature (= documented bug)
that it removes foreign key definitions.
You should define all your indexes within the table create statement, like
in:
CREATE TABLE pare
