Page 1 of 1

Limit for auto_increment

Posted: Wed Feb 13, 2008 8:53 am
by my_raj_raj2
Hi all,

I set auto_increment for int data type.

Any limit for that auto_increment?? If it reaches that value then what happens??

Thx in advance.

Re: Limit for auto_increment

Posted: Thu Feb 14, 2008 2:27 pm
by Kieran Huggins
it will auto increment until it reaches the limit of the var type for that column, then I believe you'll get an error. The MySQL docs would likely say for sure.

Just use a big integer and you'll never have to worry.

Re: Limit for auto_increment

Posted: Sat Feb 23, 2008 5:37 am
by my_raj_raj2
Thanks Kieran Huggins.

I will change it to Big integer