I use phpMyAdmin to manage my databases. I have a table with about 600 rows. Every row has a unique id field. I had all my rows going from 1-600 but i had to delete some of them. I deletet row 469, 458 and some other ones but their id is not in the database anymore. My table still goes from 1-600 but it is missing the two rows i deleted. Is there any way to rebuild the table so that now i have a table from 1-598 and the id column is not skipping any numbers?
The id column is set to a smallint and autoincrement.
Any php/mysql function that will rebuild a table based on certain column order?
I could very easily do a program for it but i dont want to go through the trouble of messing with a 600 row column.
Thanks.
ed
