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 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 :) Thank you
-- Aman Raheja AGF Inc.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
