Sql auto_increment

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