mysql column key mul_mysql> desc stu ;name在key字段出现MUL，这个MUL是什么意思？索引和主键名称都会出现在Key字段里吗？...

mysql>descstu;+-------+-------------+------+-----+---------+-------+|Field|Type|Null|Key|Default|Extra|+-------+-------------+------+-----+---------+-------+|id|int(11)|N...

mysql> desc stu ;

+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| id | int(11) | NO | | NULL | |

| name | varchar(50) | YES | MUL | NULL | | -----此处的MUL 是什么意思？？？

| depid | int(11) | YES | | NULL | |

+-------+-------------+------+-----+---------+-------+

3 rows in set (0.02 sec)

mysql> show create table stu \G;

*************************** 1. row ***************************

Table: stu

Create Table: CREATE TABLE `stu` (

`id` int(11) NOT NULL,

`name` varchar(50) DEFAULT NULL,

`depid` int(11) DEFAULT NULL,

KEY `namesy` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

ERROR:

No query specified

mysql>

展开