I have a primary key with AUTO_INCREMENT.
I can’t change the starting value with ALTER TABLE users AUTO_INCREMENT=1000.
It is always 2^31-1 which is 2147483647, the signed 32 bit integer limit.
I use signed BIGINT(12) which has a max value of 2^63-1
I’m sorry, but I don’t understand the issue exactly. Why can’t you change the auto increment starting value exactly? And what does having INT vs. BIGINT have to do with it?
1 Like
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.