Error This table does not contain a unique column

1

When viewing the tables, show me this message:

  

This table does not contain a unique column.       Grid edit, checkbox, Edit, Copy and Delete are not available.

I can not change mySQL data. You do not have the edit button.

Thank you

    
asked by anonymous 23.04.2015 / 18:37

1 answer

1
  

This table does not contain a single column.

You need to define a primary key (column that differentiates one row from the others).

When you use the interface buttons, phpMyAdmin makes the changes through the primary key of the line in question. For example, when you change the value of a field, it executes SQL as in the template below:

UPDATE tabela SET campo = "valor" WHERE chave_primaria = "valor_da_chave_primaria"

Because the table does not have a primary key, it does not provide these buttons because it can not perform the operation only on that row. If it tries for another field, it can affect another line that has the same value.

    
23.04.2015 / 20:06