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.