mySQL primary key oddity

Vote count:

0

I have a script which INSERT's data into a table and then later on when you INSERT new data it DELETE's the previous record/s and INSERT's the current data set.

The only issue is that the primary key gets wacked.

e.g. first four rows

1
2
3
4

then when i delete these and enter new data

5
3
4
6

note: the above numbers represent primary key id auto incrementations

Why does the incrementation become confused almost?

edited 30 secs ago

juergen d

81.8k

asked 1 min ago

Aiden

74

mySQL primary key oddity