Solution to phpMyAdmin error "This table does not contain a unique column"

Once I needed to change some data in a MySQL database, I decided to use phpMyAdmin and ran into a message:

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

You can solve this by running the following sql query, which will add a unique column to the table by which you can determine line numbers:

ALTER TABLE table_name add newid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

But in order not to change the structure of the table, I just changed the necessary sql data with a query. For instance:

UPDATE table_name SET serv='131' WHERE user='767' AND date='2016-02-04' AND serv='64';

That’s all. The message above indicates that it is impossible to change data through phpMyAdmin, but they can be changed by executing sql request.

Solution to phpMyAdmin error “This table does not contain a unique column”