At 18:13 -0500 2/15/03, Barry Pollock wrote:
>I am using mysql Ver 12.16 Distrib 4.0.7-gamma, for pc-linux-gnu (i686)
>I created the following table without error.
>The index line should have prevented the success of the command.
It may not make any sense, true, but it's not syntacticallyy invalid.
You'll probably also find that you can create the same index multiple
times.
>
>CREATE TABLE IF NOT EXISTS catalog.junk (
>hat VARCHAR(14) DEFAULT '' NOT NULL,
>hats VARCHAR(14) DEFAULT '' NOT NULL,
>house VARCHAR(14) DEFAULT '' NOT NULL,
>houses VARCHAR(14) DEFAULT '' NOT NULL,
>KEY hats (hats,house,house,house,house,house)
>) TYPE = ISAM;
>
>As you can see the field `house' is repeated in the `KEY' line
>Barry
