mark mcaulay wrote:
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.
That's not what MUL means. MUL means that the index is not unique --
i.e., you can have several rows with the same indexed column values.
For example, a primary key column (usually an ID) is unique. But if you
have a database of employees and you want to index them by first name,
you would not use a unique index on the "first_name" column.
4 messages in com.mysql.lists.gui-toolsRe: adding a column to a table at the...