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

phpmyadmin

Solution

I have been faced with this problem. The cause is your table doesn't have a primary key field. And I have a simple solution: Set a field to primary key to specific field that suits your business logic. For example, I have database `thesis_db` and field `thesis_id`, I will press button Primary (key icon) to set `thesis_id` to become primary key field:

Problem

The error generated in phpMyAdmin is: This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. What does this error message mean and how can I fix it?

Original source

Related problems