Boy I think I really screwed something up.
Well, I’ve been working with an already existing mySQL database that was designed by someone else (whom I don’t have contact to) so I’m still learning.
I am working in phpMyAdmin. I have a table named access_priv.
In that table I have two columns: ‘id’ and ‘name’.
Then my indexes are as follows:
Keyname Type Cardinality Field
id INDEX 237 id
name INDEX 14 name
Before there was another Keyname of PRIMARY, with type being PRIMARY and fields of id and name.
I deleted this.
Now when I browse this table, there over 1,000 pages, when before there were only 9.
What the hell did I do, and how can I fix this?