Posted by KDCinfo on 05/09/06 16:08

Turns out the real culprit is my lack of understanding of what MUL is,
and how to get past that to see where the Unique value is. When I
assign a field to be Unique, MySQL displays it as MUL instead.

I posted a message in the MySQL Newbie forum asking if anyone can
explain what the MUL field attribute is.

Thanks.

Keith D Commiskey


CREATE TABLE `loaner_condition` (`ConditionID` int(11) NOT NULL
auto_increment, `Condition` varchar(50) default '', PRIMARY KEY
(`ConditionID`), UNIQUE KEY `Condition` (`Condition`)) ENGINE=MyISAM
DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

==

mysql> describe loaner_condition2;
+-------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+----------------+
| ConditionID | int(11) | | PRI | NULL | auto_increment |
| Condition | varchar(50) | YES | MUL | | |
+-------------+-------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

[Back to original message]