> I'm using InnoDB tables. I've set one of my fields to auto increment.
> This field has a relationship with another table. I need to
> reset auto increment back to 1 after it reaches the max value (And it
will).
A you sure about that last? If you use BIGINT (63 bits), at 1000 inserts
per second (a generous rate, IMO), you will not run out for over 200
million years. May I suggest that when it fially does run out, it wioll be
Someone Elses Problem?
If this is not acceptable, put $1 in an interest bearing account today.
After about 100 million years, withdraw the sum and use it to pay MySQL AB
to implement 128 bit ints. That should see you out for the rest of the
lifetime of the universe.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
