--- 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?
>
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
uot;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:
>
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 DESCRIB
lt;[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);
>>>Query OK, 0 rows affected (0.05 sec
- 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
| Key | Default | Extra |
>+---+-+--+-+-+---+
>| FLD1 | 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
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
On Sat, Jul 28, 2001 at 08:40:15AM -0700, Michael Collins wrote:
> 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.
>
&
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
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:
I have a table that shows MUL in the key field column, what does that indicate?
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra
]>
To: "'Mysql (E-mail)'" <[EMAIL PROTECTED]>
Sent: 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 doc
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
14 matches
Mail list logo
