N
N
nfedyk2012-02-02 00:05:00
MySQL
nfedyk, 2012-02-02 00:05:00

Auto_increment jump in MySQL

I looked through the tables in the database, and saw that auto_increment for one of the tables jumped a lot of values. MySQL version 5.0.45. I can not find an explanation for such a miracle.
userId
1013
1014
3310001
3310002
Has anyone come across such miracles?

UPD. Such crooked hands of users. Question removed. Thank you.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sekira, 2012-02-02
@Sekira

Someone once manually created a record with userId 33310001 and went on from that number.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question