It's created when that field is the first field in a multi-field index.
For example:
mysql describe mytable;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| id| int(11) | YES | |
thanks,
that did the trick just fine.
shon
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Shon Stephens' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, February 01, 2002 11:55 AM
Subject: RE: what type of key is this?
It's created when that field is the first field
At 10:55 -0600 2/1/02, Rick Emery wrote:
It's created when that field is the first field in a multi-field index.
That's always what I think at first when I see MUL, too.
Actually, it means the column is part of a non-unique index.
For example:
mysql describe mytable;