- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What do column flags mean in MySQL Workbench?
In MySQL Workbench, column flags can be used with a column to maintain integrity. The column flags are as follows −
PK − Primary Key
NN − NOT NULL
BIN − Binary
UN − Unsigned
UQ − Unique
ZF − Zero Filled
G − Generate Column
AI − Auto Increment
Let us learn about them one by one −
This stands for the primary key. It can be used to make the column as a primary key.
It is for NOT NULL. Used to enforce the column that it will not insert a NULL value.
This stands for Binary. This can be used to store data as a binary string.
It is for Unsigned and can be used to store an only positive value which can be started from 0.
UQ is for Unique. This can be used to enforce the column to insert only unique value for a specific column.
ZF is for Zero Filled. Suppose, we have declared int(3) and you want to store 21, then zero filled would output the result 021.
G stands for Generated column.
AI is for AutoIncrement.
Here is the snapshot of column flags visible under MySQL workbench.
- What does the [Flags] Enum Attribute mean in C#?
- Declare syntax error in MySQL Workbench?
- What do you mean by database view and how do MySQL views work?
- What do you mean by default MySQL database for the user?
- What Are Krugerrands and What Do They Mean?
- What do you mean by C++ Tokens?
- What do you mean by corporate culture?
- What do you mean by compliance specialist?
- What do you mean by Teen Stress?
- What do you mean by performance testing?
- What do you mean by timeOut in TestNG?
- What do you mean by Listeners in TestNG?
- What do you mean by glue in Cucumber?
- What do you mean by schedule in DBMS?
- What do you mean by Scope of variables inside MySQL stored procedure?