mysql have a function , that is once i delete one row, it will automaticly remember which row i have deleted ,and when i insert a new row , it will automaticly go to last delete record's position . that is annoy me .
so ,every time i delete an old row ,and insert a new row , the new row will go to old row's position ,
let said totally i have 10 rows ,
i deleted a row ,it's position at 4th row .
now remaining 9 rows , now i want to insert my row to 10th row . but actually i insert to 4th row .how can i insert it to 10th row ?
because i display my items separate to different pages depending on how many rows .
the row's id larger , the row's content newer.if you have other new idea . can you let me know how you solve this problem . thank you !
so ,every time i delete an old row ,and insert a new row , the new row will go to old row's position ,
let said totally i have 10 rows ,
i deleted a row ,it's position at 4th row .
now remaining 9 rows , now i want to insert my row to 10th row . but actually i insert to 4th row .how can i insert it to 10th row ?
because i display my items separate to different pages depending on how many rows .
the row's id larger , the row's content newer.if you have other new idea . can you let me know how you solve this problem . thank you !