Tuesday, November 13, 2012

What do column flags mean in MySQL Workbench?

In MySQL Workbench table editor, there are 7 column flags available:

PK - Primary Key
NN - Not Null
BIN - Binary
UN - Unsigned
UQ - Create/remove Unique Key
ZF - Zero-Filled
AI - Auto Increment

MySQL Workbench provides DBAs and developers an integrated tools environment for:
  • Database Design & Modeling
  • SQL Development (replacing MySQL Query Browser)
  • Database Administration (replacing MySQL Administrator)

No comments:

Post a Comment