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

2010-01-25 Thread Nathan Rixham 
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?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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

2010-01-25 Thread John Meyer 

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: my...@lists.mysql.com (though I understand the 
cross-pollination)



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php