19 Apr
2011
19 Apr
'11
5:43 p.m.
Anybody observed, the auto-increment fileds in a table is NOT always incremented by 1 with each row insert. But as per SQL manual it should be increased by 1.
Is this behavior Ok? Or I am doing something wrong.
Note: I do not write any value to this coulmn in my INSERT statement, this coulmn values are set by system automatically.
Values I have seen for auto-incrment field -> 1,2,3,4,8,9,10,18,19,20 etc... So in between the values incremented by more than 1.
Thanks Austin