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.
See also my article: