Menu
I am using MySQL Workbench 6 CE to create some tables for a new schema I made.
When I create the new table, the application displays a tab which allows me to edit the table name (by default, the name is new_table), select the schema default, and add a comment for the table (though doing that seems to generate syntax errors in the generated SQL).
What it does not do is allow me to specify or configure any of the columns for the table. There is an entire column section that is completely greyed out.
I am logged in as root and root has all privileges for this schema.
Have I found a bug, or is there something special I need to do in order to allow column specification in a table???
Someone please advise...
UPDATE: Adding screenshot as requested...
402
To add a column, click the Column Name field in an empty row and enter an appropriate value. Select a data type from the Datatype list. Select the column property check boxes as required according to the list of column properties that follow. For a description of each item, see CREATE TABLE.
Fix the Read-Only Table in MySQL Workbench. Move your mouse over the "Read Only" text to fix the read-only table in MySQL Workbench. A tooltip will appear that shows what's wrong. The tooltip shows that the table needs a unique row identifier.
To access the MySQL Table Editor, right-click a table name in the Navigator area of the sidebar with the Schemas secondary tab selected and click Alter Table. This action opens a new secondary tab within the main SQL Editor window.
Right click the table shown at the left in Schema tab of workbench and then select Alter Table . You will get a window like this -> Here you can see the column names available, edit here and click on apply.
Click on the encircled double arrow
You will now be able to edit columns. Click on any column name, grey area will become editable now.
163
When you started creating a new table you can simply add columns by double clicking the empty placeholder row:
29
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
