List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 15 2003 11:45pm
Subject:Re: mysql Digest 15 Feb 2003 14:31:06 -0000 Issue 2312
View as plain text  
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

Thread
Re: mysql Digest 15 Feb 2003 14:31:06 -0000 Issue 2312Barry Pollock16 Feb
  • Re: mysql Digest 15 Feb 2003 14:31:06 -0000 Issue 2312Paul DuBois16 Feb