resynchronize mysql entry id's ?
Aloha,Earlier today i deleted a whole bunch of records from a table on a mysql database that powers my webiste.
On the table that these records are on, there are 3 colums: id, entry, and ip.
The id column is which all my data is sorted by, and that colum uses auto_increment to generate it's id.
Now, the problem I am facing is that there are a whole bunch of missing entries on the table, and I'm just looking for an easy way to resync the table so that all those missing id's are used again.
Thanks.