This table does not contain a unique column. Eh?

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

Moderators: macek, egami, gesf

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

This table does not contain a unique column. Eh?

Postby lister » 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....

Image

pbs
New php-forum User
New php-forum User
Posts: 39
Joined: Sat May 11, 2013 1:40 am
Location: Nashik, India
Contact:

Re: This table does not contain a unique column. Eh?

Postby pbs » Tue Sep 10, 2013 9:30 pm

set primary key for auto increment field


Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 1 guest

cron