At 16:37 -0600 2/27/03, Aman Raheja wrote:
>Suppose I have a table in mysql with a column name ID int(5) primary key
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 the integer is reached?
You get a duplicate key error.
>2> What are those limits?
The upper range of the column type. These limits are documented
in the manual. If you make the column UNSIGNED, the range is higher,
so you should do that for an AUTO_INCREMENT column.
>I am not a hardcore database person, though do some database stuff for a
>company, so accept the novice question :)