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.
>
> Thank you, but what does "MUL" stand for? "Multiple" keys?
The same value can occur "multiple" times in the index, perhaps?
> I suppose it is a key since I created an index on that field.
You really want to use "SHOW KEYS FROM <table>" to get information
about the indexes. Using "DESCRIBE <table" doesn't tell you the whole
story.
Jeremy
--
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 42 days, processed 330,954,548 queries (90/sec. avg)
