列标志在MySQL Workbench中是什么意思? [英] What do column flags mean in MySQL Workbench?

问题描述

在MySQL Workbench表编辑器中，有7个列标志可用:PK，NN，UQ，BIN，UN，ZF，AI.

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

PK显然代表主键.别人呢?

PK obviously stands for Primary Key. What about others?

推荐答案

PK-主键

NN-不为空

BIN-二进制(将数据存储为二进制字符串.没有字符集，因此排序和比较基于值中字节的数字值.)

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-无符号(仅非负数.因此，如果范围是-500至500，而不是其0-1000，则范围是相同的，但从0开始)

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)

UQ-创建/删除唯一密钥

UQ - Create/remove Unique Key

ZF-零填充(如果长度像INT(5)一样为5，则每个字段都用0填充到第5位数字.12= 00012，400 = 00400，等等)

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

AI-自动递增

G-生成的列.即由公式根据其他列生成的值

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

这篇关于列标志在MySQL Workbench中是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！