Re: Re: MySQL ID -- what happens when you run out of range?

From:	John Meyer	Date:	Mon, 25 Jan 2010 20:38:37 +0000
Subject:	Re: Re: MySQL ID -- what happens when you run out of range?
References:	1 2	Groups:	php.general
Request:	Send a blank email to php-general+get-301415@lists.php.net to get a copy of this message

On 1/25/2010 1:19 PM, Nathan Rixham wrote:

Parham Doustdar wrote:
Hello there, A friend called me today and was wondering what happens if the ID colomn of an MYSQL database, set to autoinc reaches the int limit. Will it return and begin choosing the ID's that have been deleted, or... what?
you change it to bigint before that happens :) for a more accurate answer ask on the mysql forum?

Or the e-mail list: mysql@lists.mysql.com (though I understand the cross-pollination)