MySQL DDL Column Edit is Disabled. Why?

[WWGD]

Hi All,
I am using MySQL in order to design an ERD (Entity Relation Diagram) , and I can make use of
indexes, triggers, etc. but for some reason, the columns tab , which allows me to add data or just edit the
tables is disabled. I have searched online without success. Any ideas on how to enable it ?
Thanks.

 

[Samy_A]

Hi All,
I am using MySQL in order to design an ERD (Entity Relation Diagram) , and I can make use of
indexes, triggers, etc. but for some reason, the columns tab , which allows me to add data or just edit the
tables is disabled. I have searched online without success. Any ideas on how to enable it ?
Thanks.

What client are you using?

 

[cpscdave]

Do you have an pkey defined for the table?
I've noticed similar behavior in phpMyAdmin when a pKey hasn't been specified.

 

[WWGD]

What client are you using?

Sorry, it is MySQL workbench. @cpscdave : I cannot even get to the point of choosing a PK for the table

 

[Samy_A]

Do you have an pkey defined for the table?
I've noticed similar behavior in phpMyAdmin when a pKey hasn't been specified.

Good catch.

Sorry, it is MySQL workbench.

I tried it with a table with no PK. MySQL Workbench doesn't let me edit table data. phMyAdmin and HeidiSQL do let me edit table data.

 

[cpscdave]

Good catch.

I tried it with a table with no PK. MySQL Workbench doesn't let me edit table data. phMyAdmin and HeidiSQL do let me edit table data.

Maybe there is a setting in phpMyAdmin that disables this. I don't have any other admin tools installed currently so can't try them out :)

 

[WWGD]

Maybe there is a setting in phpMyAdmin that disables this. I don't have any other admin tools installed currently so can't try them out :)

Thanks for your advice, cpscdave, but I cannot even get to choose a PK for the table.

 

[Samy_A]

Thanks for your advice, cpscdave, but I cannot even get to choose a PK for the table.

My MySQL Workbench is friendlier, and let's me add the PK.

Can you execute the DDL code to create the PK?

 

[WWGD]

My MySQL Workbench is friendlier, and let's me add the PK.

Can you execute the DDL code to create the PK?

Thanks, Samy_A, never done it before, could you please suggest a ref for how to do it? I know how to use DDL in general to create and populate (insert values into) tables, but I have never done it in MySQL workbench.

 

[Samy_A]

Thanks, Samy_A, never done it before, could you please suggest a ref for how to do it? I know how to use DDL in general to create and populate (insert values into) table, but I have never done it in MySQL workbench.

Enter the code in a SQL panel:

ALTER TABLE `test`.`nokey` 
CHANGE COLUMN `Column 1` `Column 1` INT(11) NOT NULL 
, ADD PRIMARY KEY (`Column 1`) ;

Click on the button with the lightning to execute the statement.