Where did the "auto-index 4,294,967,296"?

Frothy tasty and оWHOенного you, ALL wise

There is a small table: one field is int(10) auto_increment, the last value of — 98.
There are CMS who occasionally writes to this table at the command of the admin "Create new record".

Today, create another entry, and instead of a regular id = 99 see 4294967295.
Further, to create anything from impossible.

Nearby is a clone of the same project for testing and everything is fine. But since the contents of the database are different, stupid cannot be copied.

We still have questions:
1. where DB took that she had "auto-index 4,294,967,296" ?
2. and this cant be fixed?

Mercy, bul-bul, 2 times "ku" and so on.
September 19th 19 at 12:31
2 answers
September 19th 19 at 12:33
Solution
So you change the last key to 99, and change the value of AI at 100
UPDATE FROM <table name> SET id=99 where id=4294967295
ALTER TABLE <TableName> AUTO_INCREMENT=100
Chord, about ALTER TABLE, I didn't realize... merci.
And where did this bug come from? - Tyson.Kessler48 commented on September 19th 19 at 12:36
September 19th 19 at 12:35
This is 2^32 - 1, so that the overflow somewhere is the place to be...
Is MySQL decided that the next auto-increment it will look like this. Although previous 98.
I wonder why. - Tyson.Kessler48 commented on September 19th 19 at 12:38

Find more questions by tags MySQL