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. But if you do it with a signed tinyint, you'll only need 128 inserts to find out. :-) > 2> What are those limits? Depends on the column type. Check here for sizes: http://www.mysql.com/doc/en/Storage_requirements.html An INT is 4 bytes. If you declare it unsigned, that's 2**32 or 2**31 if signed. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 24 days, processed 749,803,197 queries (354/sec. avg) --------------------------------------------------------------------- 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