CODEWITHSUNDEEP
phpmysqlphpmyadmin
Maggi Iggam
Maggi Iggam

Reputation: 692

In Phpmyadmin edit values inserted in table is not working

If you see in the picture , i am not getting any option to edit inserted values in table. I wanted to edit here for ex , 'test_input' coloumn for the only entry. Why is this happening , i am on Localhost and newly installed xampp.

screenshot of phpmyadmin

Upvotes: 2

Views: 2104

Answers (1)

D4V1D
D4V1D

Reputation: 5849

This is because you don't have a PRIMARY key in your table.

Add id field and set it to be the PRIMARY key of your table (or choose one of the existing field, such as problem_id, but it must be UNIQUE).

This is exactly the notice displayed on top of your attached phpMyAdmin screenshot warns you about:

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

Upvotes: 8

Related Questions