Tag Archives: workbench

[Solved] MySQL uses the workbench tool, and the table status is read only

Solution:

If the primary key is not set in the database table in MySQL, you cannot edit the data directly in the workbench, you must set PK and NN.

Expansion:

– PK: primary key (column is part of a pk)

– NN: not null (column is nullable)

– UQ: unique (column is part of a unique key)

– AI: auto increment (the column is auto incremented when rows are inserted)

– BIN: binary (if dt is a blob or similar, this indicates that is binary data, rather than text)

– UN: unsigned (for integer types, see docs: “10.2. Numeric Types”)

– ZF: zero fill (rather a display related flag, see docs: “10.2. Numeric Types”)