02.07.2016, 16:32
Auto Increment will increase the houseid one by one.
Consider that i have 4 houses (0, 1, 2, 3) and i have deleted houseid 1 for example, when i create a new house using the command, it will assign houseid 4 instead of the missing id (1) .. i need something to get the missing id to assign it as the new houseid.
Konstantinos can you show me a simple code so i can get to the point ?
Thank you
Consider that i have 4 houses (0, 1, 2, 3) and i have deleted houseid 1 for example, when i create a new house using the command, it will assign houseid 4 instead of the missing id (1) .. i need something to get the missing id to assign it as the new houseid.
Konstantinos can you show me a simple code so i can get to the point ?
Thank you