On Mon, Jan 25, 2010 at 17:15, Parham Doustdar <parham90@xxxxxxxxx> 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/
