mysql , after a deletion, last inserted row sits just in the place of the deleted one

I am not going to paste the code here and hope the statement of the prob is enough to pose the question .

i inserted 3 rows in a mysql table, deleted the 2nd one and then inserted the 4th one and all these things i did by writing code in php. but the 4th one sits in the place of the deleted one. That is I wanted the order of the ids(primary key) to be 1,3,4. but now it be开发者_JAVA百科comes 1,4,3.

Thanks in advance for any solution.

Istiaque Ahmed Bangladesh

---

if you dont specify the sort order in your query then the db can return the rows in any order, so specify the sort order and all will be well

---

Change the table storage engine to InnoDB.

MyISAM and InnoDB