This table does not contain a unique column. Eh?

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: egami, macek, gesf

Post Reply
New php-forum User
New php-forum User
Posts: 21
Joined: Mon May 16, 2011 8:18 am

Tue Sep 10, 2013 7:47 am

Im a little lost (i am totally new) and cant seem to solve this error:

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

This is reference to my newly created DB and table. I executed a very simple SQL query "SHOW TABLES" which works fine but then it shows me this error...

Is this caused by me having two 'primary columns'? - I have tried just to have one but MySQL keeps wanting to make 2 primary tables....

Thanks for your patience - all advice is REALLY helpful!

* I worked out that this error is relevant to this particular SQL Query command - but, still, it's an error that im keen to solve....

php-forum Fan User
php-forum Fan User
Posts: 53
Joined: Sat May 11, 2013 1:40 am
Location: Nashik, India

Tue Sep 10, 2013 9:30 pm

set primary key for auto increment field
Post Reply