Hello,
When I do a table describe, I see a MUL on a column I have marked as a
foreign-key. I tried searching for MUL within the docs, but do not see a
concise explanation of what that is?
Anyone?
Thanks,
Scott
--- Scott Purcell [EMAIL PROTECTED] wrote:
Hello,
When I do a table describe, I see a MUL on a column I have marked as
a
foreign-key. I tried searching for MUL within the docs, but do not
see a
concise explanation of what that is?
Anyone?
Thanks,
Scott
mysql CREATE TABLE X (FLD1 INT UNIQUE);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE X;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| FLD1 | int(11) | YES | MUL | NULL
| int(11) | YES | MUL | NULL| |
+---+-+--+-+-+---+
Doesn't MUL mean a key can exist multiple times
in the index?
Right. It means it's part of a non-unique index.
I am using 3.23.49-max-debug
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Andy Sy [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 2:45 AM
Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
At 2:03 +0800 6/14/02, Andy Sy wrote:
mysql CREATE TABLE X (FLD1 INT UNIQUE
Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
At 2:03 +0800 6/14/02, Andy Sy wrote:
mysql CREATE TABLE X (FLD1 INT UNIQUE);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE X;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra
At 3:35 +0800 6/14/02, Andy Sy wrote:
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Andy Sy [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 2:45 AM
Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
At 2:03 +0800 6/14/02, Andy Sy wrote
Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
At 2:03 +0800 6/14/02, Andy Sy wrote:
mysql CREATE TABLE X (FLD1 INT UNIQUE);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE X;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra
On Fri, Jul 27, 2001 at 09:29:20PM -0700, Michael Collins wrote:
I have a table that shows MUL in the key field column, what does
that indicate?
That means it's a non-unique key.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408
At 11:08 PM -0700 7/27/01, Jeremy Zawodny wrote:
I have a table that shows MUL in the key field column, what does
that indicate?
That means it's a non-unique key.
Thank you, but what does MUL stand for? Multiple keys?
I suppose it is a key since I created an index on that field
I have a table that shows MUL in the key field column, what does that indicate?
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra
Hi All
Problmes with mysql keys
When id do show columns from ACCOUNTING; in the Key field is see MUL.
Looking at the tec docs I can not find which type of key this is referring
to. Can some one tell me.
Thanks Simon
-
Before
: Thursday, April 26, 2001 8:04 PM
Subject: MUL
Hi All
Problmes with mysql keys
When id do show columns from ACCOUNTING; in the Key field is see
MUL.
Looking at the tec docs I can not find which type of key this is
referring
to. Can some one tell me.
Thanks Simon
13 matches
Mail list logo