Can not create table in MySQL workbench 5.2.40

2019-06-20 20:28发布

问题:

I've just created anew schema & want to create a new table. When ever I right click on 2myschema' that I created, and select 'new table',

I give a name for the table to be created, but I get the following error:

I searched about the error, and I found that the cause if I typed a reserved word such as 'order' but there is no way that table2 is reserved word, and I tried many different names and always get the same message. The column Name is not activated, so I can't enter column names.

回答1:

I figured out that the columns area was not disabled, but it needed scroll down from the thin rectangle as shown below. I was trying to type column name in the square below this rectangle and beased on that I described it as disabled.



回答2:

You don't need to scroll down but make your window taller. You have an extremely small WB window height. On the right hand side of the table editor there's also a double arrow pointing down. Click this to collapse the upper part (with the collation and comments edits) and you will get more room for the lower part.

Note: there's also a splitter between the table editor and the output tab, so you can increase the table editor space by sacrifying some output space.



回答3:

You are trying to create a table without columns. That is not possible



回答4:

You have no columns in your table, so what should your table represent?