Prev: How to change a filename for download (e.g. jpeg, pdfetc.)
Next: XAMPP PHP 4/5
From: "Parham Doustdar" on 25 Jan 2010 15:15
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?
Thanks!


From: Nathan Rixham on 25 Jan 2010 15:19
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?
From: Joseph Thayne on 25 Jan 2010 15:22
It will continue to use the max number which of course will cause an error.

Joseph

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?
> Thanks!
>
>
>
>
From: John Meyer on 25 Jan 2010 15:38
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(a)lists.mysql.com (though I understand the
cross-pollination)

From: Robert Cummings on 25 Jan 2010 15:39
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?
> Thanks!

Ask Slashdot... I believe they hit the limit one day (several actually)
for comments :)

Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP
 |  Next  |  Last
Pages: 1 2 3
Prev: How to change a filename for download (e.g. jpeg, pdfetc.)
Next: XAMPP PHP 4/5