Menu
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.
254
To solve 'MySQL ERROR 1005: Can't create table (errno: 150)' you likely just have to ensure that your foreign key has the exact same type as the primary key.
In order to start adding data to a table, right-click the table (in the SCHEMAS pane) to be modified and click Select Rows. You will then find yourself in a window that allows you to enter data (Figure E). In this window, you can either use the result grid or open the form editor.
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.
79
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
