Maximum value of AUTO_INCREMENT in Mysql

2020-09-19 08:47:57 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