What do column flags mean in MySQL Workbench

Question

In MySQL Workbench table editor there are 7 column flags available  PK  NN  UQ  BIN  UN  ZF  AI   PK obviously stands for Primary Key  What about others

User · Answer

Here is the source of these column flags  http   dev mysql com doc workbench en wb-table-editor-columns-tab html

User · Answer

This exact question is answered on 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    That means hover over an acronym in the mySql Workbench table editor   Section 8 1 11 2     The Columns Tab

User · Answer

PK  - Primary Key  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   UQ  - Create remove Unique Key  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  - Auto Increment  G - Generated column  i e  value generated by a formula based on the other columns

[sql] What do column flags mean in MySQL Workbench?

Examples related to sql

Examples related to mysql

Examples related to mysql-workbench