# Cardinality rising

**URL:** <https://forum.kirupa.com/t/cardinality-rising/162409>\
**Category:** Uncategorized\
**Created:** [September 13, 2005, 4:36am UTC](https://forum.kirupa.com/t/cardinality-rising/162409 "2005-09-13T04:36:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dru\_nasty](https://avatars.discourse-cdn.com/v4/letter/d/90db22/32.png) [@dru\_nasty](https://forum.kirupa.com/u/dru_nasty)\
**Post date:** [September 13, 2005, 4:36am UTC](https://forum.kirupa.com/t/cardinality-rising/162409/1 "2005-09-13T04:36:01Z")

</div>

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?