At 18:38 -0500 6/28/04, mark mcaulay wrote:
>Hi, three things that could be improved with Console Manager 0.9.4:
>1. although you can insert a column within the table, you can't add
>a column at the end of the table in
>
>2. it asks you whether you want to save the changes to the table
>structure even though you've already saved it using the save button.
>This is unnecessary.
>
>3. when viewing the design, it shows indexes as MUL for multiple,
>when there are indexes on only one column. It would be good to have
>the distinction between single and multiple column indexes. An
>example could be colour coding so you can see which index is on
>which columns.
If MUL here has the same meaning as for the DESCRIBE or SHOW COLUMNS
statements, it doesn't refer to the number of columns in the index.
Rather, it indicates that the index allows multiple instances of a given
value. (That is, the index is not unique-valued.) Note that a UNIQUE
index on a NULL column shows up as MUL because the index allows multiple
NULL values.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
