We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT.
After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY.
You are wasting half your range by not saying UNSIGNED. Not your problem (I think) but still an error.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]