本文介绍了SQL 键,MUL 与 PRI 与 UNI的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
MySQL中MUL
、PRI
和UNI
有什么区别?
What is the difference between MUL
, PRI
and UNI
in MySQL?
我正在使用以下命令处理 MySQL 查询:
I'm working on a MySQL query, using the command:
desc mytable;
其中一个字段显示为 MUL
键,其他字段显示为 UNI
或 PRI
.
One of the fields is shown as being a MUL
key, others show up as UNI
or PRI
.
我知道如果一个键是 PRI
,那么每个表只能有一条记录与该键相关联.如果一个键是 MUL
,那是否意味着可能有多个关联记录?
I know that if a key is PRI
, only one record per table can be associated with that key. If a key is MUL
, does that mean that there could be more than one associated record?
这是mytable
的响应.
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| courseid | int(11) | YES | MUL | NULL | |
| dept | char(3) | YES | | NULL | |
| coursenum | char(4) | YES | | NULL | |
+-----------+---------+------+-----+---------+-------+
推荐答案
表示该字段是(部分)非唯一索引.你可以发出
It means that the field is (part of) a non-unique index. You can issue
show create table <table>;
查看有关表结构的更多信息.
To see more information about the table structure.
这篇关于SQL 键,MUL 与 PRI 与 UNI的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!