Hi, I'm using a mysql table to store small messages in a p2p messaging server.
The primary key (message_id)is a UNSIGNED BIGINT, Which is supposed to be 64 bit, with autoincrement. The each row is deleted as soon as it is fetched By the client, and also after the expiry of a period (~30 days). 64 bits does provide a large number, but there is a possibility that it won't be enough. My question is, does the autoincrement count rollover To zero normally, or will the rollover cause an error? Or is there a better way to tackle the problem ? Thanks, Jeethu Rao --------------------------------------------------------------------- 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
