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
