I'm trying to figure out why the following happens, which seems to be very strange behavior:
If I insert data to a table which has an auto-incrementing id-column, the id does not increase as I expect it woud. In a table with 4 values (numbered 0 to 3), for example, a new row inserted began it's ID at 43, then continued to 44, 45, etc.
Another related issue is that if I restructure a table that has data present in it, the row with an id of 0 (on an auto-increment column) jumps around to a seemingly random high number, again, like 43.
Thanks if anybody has any info on this. I'm baffled.
If I insert data to a table which has an auto-incrementing id-column, the id does not increase as I expect it woud. In a table with 4 values (numbered 0 to 3), for example, a new row inserted began it's ID at 43, then continued to 44, 45, etc.
Another related issue is that if I restructure a table that has data present in it, the row with an id of 0 (on an auto-increment column) jumps around to a seemingly random high number, again, like 43.
Thanks if anybody has any info on this. I'm baffled.
Comment