List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:February 9 2011 11:41am
Subject:Auto-Increment Values in Mysql
View as plain text  
Dear all,


I have an auto-increment column in Mysql database table. Let's say the 
column has below values :


1
2
3
4
5
6
7
8
9
10


Now if i deleted some rows where id= 3 ,5 and 8

The data look like as :

1
2
4
6
7
9
10

I want to have it id's as
1
2
3
4
5
6
7
and next data is inserted right at 8

Please help how to achieve it.


Thanks & best Regards
Adarsh Sharma
Thread
Auto-Increment Values in MysqlAdarsh Sharma9 Feb
  • Re: Auto-Increment Values in MysqlMark Goodge9 Feb
  • Re: Auto-Increment Values in MysqlReindl Harald9 Feb
Re: Auto-Increment Values in MysqlJan Steinman9 Feb