Hey guys,
Ok so I have a table in mySQL that through php I delete a record. Each record is guided by pic_ID which is also the primary key of the table. The problem is say I have 10 records and I delete record number 5, records 6 through 10 disappear. I know why this happens but part of the solution is that I need to re increment the primary key starting from 1 so that all the numbers are in order again instead of having a missing number. How do I do this?
Ok so I have a table in mySQL that through php I delete a record. Each record is guided by pic_ID which is also the primary key of the table. The problem is say I have 10 records and I delete record number 5, records 6 through 10 disappear. I know why this happens but part of the solution is that I need to re increment the primary key starting from 1 so that all the numbers are in order again instead of having a missing number. How do I do this?