What does the ā€œGā€ column flag mean in MySQL Workbench?

See the image below, but as part of the table editor there are column flags such as PK (primary key), NN (not null), and so on. The last one is "G" Image of the MySQL table editor

+5
source share
1 answer

After reviewing some of the Workbench code and the MySQL documentation, it looks like column G is for Generated Columns .

In the source code in the mysql_table_editor_column_page file (line 132 at the time of writing):

model->model().append_check_column(MySQLTableColumnsListBE::IsGenerated, "G", EDITABLE); 

Another code in the same area gives a layout corresponding to what you see in the visual for PC, NN, etc., which is available for viewing in the source.

+4
source

Source: https://habr.com/ru/post/1238936/


All Articles