The requirement is for a numeric counter which starts from a value, gets incremented by one to a max value and then resets to the start value. Currently, I keep these on a table of counters and do the lock, read, update, unlock.
Is there a "better way" to implement this using mysql for keeping track of invoice numbers, customer numbers, receipt numbers etc? _______________________________ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]