As you can see id is underlined, so i know that is the primary column. I understand that the yellow keysindicate which columns could be set to be primary.
The U icon to the right of the grey or yellow key is slightly grey for columns: id, subtopic, topic and tp. These columns all also have yellow keys. Except the question column which has a yellow key and a grey U.
Does the grey U indicate which columns are unique?
And if so how can I make the ‘question’ column not unique. The column will just hold a int from 1 to 25.
Thanks,
Shane
Hi,
I have solved this problem, by renaming the column ‘question’ to ‘questionprev’. Then I created another column called question. Making sure that it was not unique and copied over the values from ‘questionprev’ to ‘question’. Now when I add a row, the ‘question’ does not need to be unique.
Thanks,
Shane
Hi,
I finally got rid of the grey U icon and got it to a blue U icon.
I was trying to use SQL to look at the table using,
DESCRIBE table
Then to drop the unique on the column, I was using
alter table mytable drop index mycolumn;
But this wasn’t working.
So I looked at the indexes and deleted them, well all except the id primary index.
Now all seems to be working fine.
Thanks,
Shane
I hope that this time the problem is really solved and you don’t have further problems. I do apologise if you felt that we didn’t pay enough attention to you. I confess that I can’t remember how my PHPMyAdmin shows things… I always work with direct connection and black screen.
Well done and do something nice to celebrate that you sorted it out
And thank you for sharing the solution. That’s true community spirit