I have a problem.
I am developing a website that involves users being able to delete certain rows of their own tables in a MySQL database.
Just say there is a table with 10 rows, and a column named 'id' that is auto-increment with numbers 1 to 10. If a user deletes row 4, is there any way to either shift all the data below up so that the end result is 9 rows all number 1-9 in the 'id' column?
I am developing a website that involves users being able to delete certain rows of their own tables in a MySQL database.
Just say there is a table with 10 rows, and a column named 'id' that is auto-increment with numbers 1 to 10. If a user deletes row 4, is there any way to either shift all the data below up so that the end result is 9 rows all number 1-9 in the 'id' column?