Re: auto increment limitation

[Preston McMurry]

10^3 = 1000 (max of 999)
10^4 = 10,000 (max of 9,999, not 127)
...
10^19 = 10,000,000,000,000,000,000

tinyint: -128 to 127
int: -2147483648 to 2147483647 (lots)
bigint: -9223372036854775808 to 9223372036854775807

You'll probably run into table size issues long before you run out of key values. If you really wanted to go the extra mile, and assuming table size was not an issue, you could use a GUID as the key. Unfortunately, you will have to wait for GUID implementation. (Unless you rolled your own. :-)

http://dev.mysql.com/doc/mysql/en/table-size.html

http://bugs.mysql.com/bug.php?id=8633

http://dev.mysql.com/doc/mysql/en/numeric-types.html

http://prestonm.com ... http://www.mcmurry.com