Does auto increment increase at 0 if the maximum value is reached?

Question

Does MySQL automatically reset to 0after reaching its maximum value?

In other words, if column UNSIGNED SMALLINTc AUTO_INCREMENTreaches 65535, what happens to the new INSERT?

If no values are available, what happens then?

+3

user1382306 Feb 10 '14 at 2:35

1 answer

Gordon linoff · Accepted Answer · 2014-02-10T02:37:15+0000

The documentation is pretty clear what happens:

When the column reached the upper limit of the data type, the next attempt to generate the sequence number failed.

Read about it here .

So the answer to your question is no. It generates an error.