Re: exhaust limit of auto_increment int on mysql

2003-02-27 Thread Paul DuBois
At 16:37 -0600 2/27/03, Aman Raheja wrote: Hi All Suppose I have a table in mysql with a column name ID int(5) primary key auto_increment The (5) is irrelevant. That is the display width, which has nothing to do with the range of the underlying column type. 1> What happens when the upperr limit of

Re: exhaust limit of auto_increment int on mysql

2003-02-27 Thread Jeremy Zawodny
On Thu, Feb 27, 2003 at 04:37:16PM -0600, Aman Raheja wrote: > Hi All > Suppose I have a table in mysql with a column name ID int(5) primary key > auto_increment > 1> What happens when the upperr limit of the integer is reached? Error. I don't know the specific error, because I've never tried it.