What's the difference between MUL, PRI and UNI in the MySQL?
I am working on a MySQL query, executing the command:
desc mytable;
One of the fields had been shown as being a MUL key, others show up as UNI or PRI.
I also knew that if a key is PRI, only one record per table could be associated with that key. If a key is MUL, is itt mean that there could be more than one associated records?
Here's the response of mytable.
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| courseid | int(11) | YES | MUL | NULL | |
| dept | char(3) | YES | | NULL | |
| coursenum | char(4) | YES | | NULL | |
+-----------+---------+------+-----+---------+-------+