Re: MySQL ID -- what happens when you run out of range?
| From: | Ryan Sun | Date: | Mon, 25 Jan 2010 21:49:47 +0000 |
| Subject: | 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-301420@lists.php.net to get a copy of this message | ||
For such a large data set, they would split into several sub tables,
otherwise the performance will be horrible
On Mon, Jan 25, 2010 at 3:39 PM, Robert Cummings <robert@interjinn.com>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?
>> 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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>