I have insert data into a mysql table where the primary key (UserNum) is set to null and set to auto increment. The problem is (and it is more of an annoyance than a problem) it went from 1 to ~1350 in order then jumped to something around 950000 . I would rather it just kept increasing by one rather than jumping around, does any one know why it did this and how I can keep it from doing this? Thanks.
