MUL when describe table

2006-04-10 Thread Scott Purcell
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

Re: MUL when describe table

2006-04-10 Thread Shawn Green
--- 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

Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Andy Sy
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

Re: Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Paul DuBois
| 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

Re: Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Andy Sy
- 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

Re: Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Gerald Clark
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

Re: Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Paul DuBois
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

Re: Why does Key==Mul in DESCRIBE TABLE for unique key?

2002-06-13 Thread Paul DuBois
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

Re: easy question, what is MUL

2001-07-28 Thread Jeremy Zawodny
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

Re: easy question, what is MUL

2001-07-28 Thread Michael Collins
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

easy question, what is MUL

2001-07-27 Thread Michael Collins
I have a table that shows MUL in the key field column, what does that indicate? +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra

MUL

2001-04-26 Thread Simon Green
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

Re: MUL

2001-04-26 Thread Welcome
: 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