Hey
I have a field called “id” with ‘auto_increment’ on. So, when I add something new to the table, it automatically sets a number in numerical order. When I delete an item and then add another item, the field doesn’t give the new input the lowest possible number available, it just keeps counting up higher and higher. Is there a way to make it not keep counting higher and higher and just give the ‘id’ of the input the lowest available number?
Thanks,
Brandon