I want to insert a record into database after deleting a record,but I come across some matter,for example ,the sequence of records is '1,2,3,4,5,6,7,8,',after I delete record '3 ',the sequence will change to '1,2,4,5,6,7,8'.and when I insert another record '9', the sequence will change to '1,2,9,4,5,6,7,8'but I want to get the sequence of '1,2,4,5,6,7,8,9',is there any point_function about it ?I mean the record point must change after deleting it ,I set the primary key(id) as autoincrement. can you help me?
