Entering the Greyed column from MySQL Workbench

I am using MySQL Workbench 6 CE to create some tables for the new schema I made.

When I create a new table, the application displays a tab that allows me to edit the table name (the default name is new_table), select the default schema and add a comment to the table (although this does to generate syntax errors in the generated SQL).

What he does not do is let me specify or configure any of the columns for the table. There is a whole section of the column that is completely gray.

I am registered as root, and root has all privileges for this scheme.

I found an error, or is there something special I need to do to allow the specification of a column in a table ???

Someone, please advise ...

UPDATE: adding a screenshot as requested ...

Screenshot of grayed out inputs (schema redacted for nondisclosure reasons)

+7
mysql mysql-workbench
source share
4 answers

When you started creating a new table, you can simply add columns by double-clicking on an empty placeholder row:

enter image description here

+5
source share

Click on the double surround arrow

Click on the encircled double arrow

Now you can edit the columns. Click on any column name, the editable gray area will now be available.

+9
source share

I had the same prb in MySQL Worbench 6.3.6. Here is a link to the solution. Or just drag your output panel shorter!

http://bugs.mysql.com/bug.php?id=79281

+2
source share

You must check any key to include the column name. please check PK, NN, UQ, B, etc., then the column is ready for editing. enter image description here

enter image description here

0
source share

All Articles