Problems with Deleting auto increment columns

chungas

Newbie

Join Date: Aug 2005

Posts: 1

#1: Aug 30 '05

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?

« previous question | next question »

Similar Misc bytes

ok problems entering data into database (answers)
SERIAL type - auto-increment grouped by other field (answers)
What to do with AUTO-ID column when I add a new record to the data (answers)
Multiple auto increments in one column? (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,419 network members.