What do column flags mean in MySQL Workbench?

sql mysql mysql-workbench
Ivan picture Ivan · Sep 8, 2010 · Viewed 132.8k times · Source

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?

Answer

Vasiliy Kulakov picture Vasiliy Kulakov · Sep 8, 2010

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

Related questions

Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away …

Read More
MySQL Workbench: How to keep the connection alive

Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4 …

Read More
How to generate the whole database script in MySQL Workbench?

I want to take the whole database. Where do I find the database file? And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?

Read More