List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 7 1999 10:28pm
Subject:Re: Key Field MUL (Newbie Question)
View as plain text  
At 16:19, 19990807, Sasha Pachev wrote:
>MUL means that the field is a part of an index that has other fields.

Not quite.  It means that multiple rows are allowed to have the same
value in that field.

    mysql> create table foo (bar char(10) not null, index (bar));
    Query OK, 0 rows affected (0.04 sec)

    mysql> desc foo;
    +-------+----------+------+-----+---------+-------+
    | Field | Type     | Null | Key | Default | Extra |
    +-------+----------+------+-----+---------+-------+
    | bar   | char(10) |      | MUL |         |       |
    +-------+----------+------+-----+---------+-------+
    1 row in set (0.00 sec)

Tim
Thread
Key Field MUL (Newbie Question)Anna Winkler7 Aug
  • Re: Key Field MUL (Newbie Question)Thimble Smith7 Aug
  • Re: Key Field MUL (Newbie Question)Sasha Pachev8 Aug
    • Re: Key Field MUL (Newbie Question)Thimble Smith8 Aug