Insert record into mysql table having id auto increment between two existing row

[priya171]

i have table call test

id name dob mobile

1 xyz 1989-01-11 9878785687

2 pqr 2012-01-11 9977889988

3 abc 2010-09-19 7766554433

 

 

id is auto increment. now i have to add a record between 1 and 2 like udp 1977-09-08 9898009800

 

So my data table should be like this:

id name dob mobile

1 xyz 1989-01-11 9878785687

2 udp 1977-09-08 9898009800

3 pqr 2012-01-11 9977889988

4 abc 2010-09-19 7766554433

 

Help me....

 

[Barand]

ID values are unique identifiers given to records on insert and, once allocated, should never change.

 

Your application should work exactly the same if MySql allocated ids randomly instead of sequentially (easier and quicker). If they were allocated randomly, where would you put your new record?

 

What is there about that record that makes it imperative that it go between 1 and 2?

[fenway]

Auto-increments means "I don't care about the value you choose".