it means it allow multiple records have same value in a table. i.e. It allow
index to contain duplicates.
it really is not a key. it is a kind of index instead.
if you have a table using a primary key say table_a, try to use "SHOW INDEX
FROM table_a", then "SHOW INDEX FROM ACCOUNTING". you can see their
difference. A column called Non_unique in ACCOUNTING should be equal to 1
according to your last email.
section SHOW INDEX in mySQL manual has a good explanation.
good luck.
Tony
----- Original Message -----
From: "Simon Green" <[EMAIL PROTECTED]>
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 docs I can not find which type of key this is
> referring
> to. Can some one tell me.
> Thanks Simon
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
