Can not create table in MySQL workbench 5.2.40

2019-06-20 19:42发布

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',

enter image description here

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

enter image description here

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.

4条回答
做自己的国王
2楼-- · 2019-06-20 20:19

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

查看更多
The star\"
3楼-- · 2019-06-20 20:27

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

查看更多
时光不老,我们不散
4楼-- · 2019-06-20 20:30

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.

enter image description here

查看更多
ゆ 、 Hurt°
5楼-- · 2019-06-20 20:40

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.

查看更多
登录 后发表回答