MySQL – Rearrange auto increment column values

In MySQL table have 10 rows with 1 to 10 as primary key value with auto-increment. We delete the fourth row in the table. I this situation, if we need to rearrange the auto-increment value that is 1 to 9 for already available rows, the following queries do this job:

 

ALTER TABLE <<table>> DROP <<column>>;
ALTER TABLE <<table>> AUTO_INCREMENT = 1;
ALTER TABLE <<table>> ADD <<column>> bigint UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

About selvam4win

I am Selvam. I am very jolly person and frank one.

Posted on December 31, 2011, in MySql and tagged , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: