Re: mysql Digest 15 Feb 2003 14:31:06 -0000 Issue 2312

[Paul DuBois <suppressed>]

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


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php