Help, please! Suggestions please on how to clean this up. I have a test database I am using to develop a php site and my computer crashed. Now I notice 3 million rows in a table for one item with auto_increment id numbers that somehow was added, perhaps because of the crash, don't know for sure. How to get rid of them, they are cluttering my table and causing ridiculous # of pages to scroll through? Without deleting the table and reconstructing it, is there any way to eliminate these 3 thousand entries and reset the auto_increment #s back? If so, what would the MySql command look like for this?
I am using PHPMyAdmin to manage my database.
PHP5.04, Mysql 4.1.13, Apach 2.0 on Windows XP