Reputation: 633
In phpMyAdmin it's really hard to see which column has been assigned PK. If base on the color of icon, it's doesn't make sense because I assume column with data type text have a grey icon.
Upvotes: 5
Views: 7130
Reputation: 1124
In PhpMyadmin primary key identify by underline in column name.
In your case, you have underline in task_id.
other grey color means , you can't assign primary key to that column .
Upvotes: 5