在MySQL Workbench中，列标志是什么意思?

In MySQL Workbench table editor there are 7 column flags available: PK, NN, UQ, BIN, UN, ZF, AI.

在MySQL工作台编辑器中，有7个列标记可用:PK、NN、UQ、BIN、UN、ZF、AI。

PK obviously stands for Primary Key. What about others?

PK显然代表主键。其他的呢?

3 个解决方案

#1

288

PK - Primary Key

PK -主键

NN - Not Null

神经网络——而不是零

BIN - Binary (stores data as binary strings. There is no character set so sorting and comparison is based on the numeric values of the bytes in the values.)

二进制文件(将数据存储为二进制字符串)。没有字符集，所以排序和比较是基于数值中字节的数值。

UN - Unsigned (non-negative numbers only. so if the range is -500 to 500, instead its 0 - 1000, the range is the same but it starts at 0)

Unsigned(仅限非负数)。如果范围是-500到500，而不是0 - 1000，范围是一样的但从0开始

UQ - Create/remove Unique Key

UQ -创建/删除唯一的键。

ZF - Zero-Filled (if the length is 5 like INT(5) then every field is filled with 0’s to the 5th value. 12 = 00012, 400 = 00400, etc. )

ZF -零填充(如果长度像INT(5)一样是5，那么每个字段都用0的5次方填充。12 = 00012, 400 = 00400，等等)

AI - Auto Increment

AI -汽车增量

G - Generated column. i.e. value generated by a formula based on the other columns

G -生成的列。即基于其他列的公式生成的值

#2

Here is the source of these column flags

这是这些列标志的来源

http://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html

#3

This exact question is answered on mySql workbench-faq:

这个问题在mySql workbench-faq中得到了回答:

Hover over an acronym to view a description, and see the Section 8.1.11.2, “The Columns Tab” and MySQL CREATE TABLE documentation for additional details.

将鼠标悬停在一个缩略词上以查看描述，请参见8.1.11.2节、“Columns选项卡”和MySQL创建表文档以获取更多的详细信息。

That means hover over an acronym in the mySql Workbench table editor.

这意味着在mySql工作台编辑器中悬停在一个首字母缩略词上。

Section 8.1.11.2, “The Columns Tab”

第8.1.11.2节“Columns选项卡”

#1

288