now when you want to get the next number in the sequence do:
the key here is that the sequence table is myisam, and so does not respect transactions. if you use a table that respects transactions, you will block when there are multiple transactions trying to get a sequence, whereas what you want is to just get a sequence.
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"
Joined: Jun 20, 2009
Yes, Mysql supports sequences. Please use appropriate syntax for creating sequences.