Re: MySQL ID -- what happens when you run out of range?
| From: | Camilo Sperberg | Date: | Mon, 25 Jan 2010 21:31:46 +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-301419@lists.php.net to get a copy of this message | ||
On Mon, Jan 25, 2010 at 17:15, Parham Doustdar <parham90@gmail.com> 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 what I know, MySQL will convert that number into a negative number,
which would be invalid for an auto-increment field (auto-increment ==
unsigned). That would raise an error ;)
Greetings :)
--
Mailed by:
UnReAl4U - unreal4u
ICQ #: 54472056
www1: http://www.chw.net/
www2: http://unreal4u.com/