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

by

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:

enter image description here

More Related Contents:

  1. Error in php please stop it
  2. No connection could be made because the target machine actively refused it
  3. mysql said: Cannot connect: invalid settings. xampp
  4. PHPMyAdmin Default login password [closed]
  5. How to Increase Import Size Limit in phpMyAdmin
  6. Using PHPMyAdmin to administer Amazon RDS
  7. Viewing Content Of Blob In phpMyAdmin
  8. i have an error which i dont understand. can you help me? [closed]
  9. Php foreach give 2 users random value
  10. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  11. How to display UTF-8 characters in phpMyAdmin?
  12. Restore table structure from frm and ibd files
  13. Why is the estimated rows count very different in phpmyadmin results?
  14. How to write a stored procedure using phpmyadmin and how to use it through php?
  15. Find and Replace text in the entire table using a MySQL query
  16. New xampp security concept: Access Forbidden Error 403 – Windows 7 – phpMyAdmin
  17. Mysql event error using php
  18. Is there a simple way to convert MySQL data into Title Case?
  19. WAMP/MySQL errors not in correct language
  20. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  21. Composite key as foreign key (sql)
  22. Unknown database error in PHP but it exists in PHPMyAdmin
  23. how to delete duplicate rows from a table in mysql
  24. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  25. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  26. where does MySQL store database files?
  27. How to import large sql file in phpmyadmin
  28. Import CSV to Update rows in table
  29. Auto Increment skipping numbers?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment