Maximum value of AUTO_INCREMENT in Mysql

2021-03-05 19:17:54 Sushiya Mysql

What is the maximum value of AUTO_INCREMENT?

The maximum value for AUTO_INCREMENT is the same as the maximum value for the column data type.

However, in the case of BIGINT unsigned, 18446744073709551614, which is 1 less than the maximum value, is the maximum value assigned by AUTO_INCREMENT. (Verification result in MySQL5.6.21)

This post is submitted by one of our members. You may submit a new post here.

Related Tricks