Re: MySQL ID -- what happens when you run out of range?
| From: | Nathan Rixham | Date: | Mon, 25 Jan 2010 20:19:14 +0000 |
| Subject: | Re: MySQL ID -- what happens when you run out of range? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-301413@lists.php.net to get a copy of this message | ||
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?