From: Johan De Meersman Date: April 22 2010 11:12am Subject: Re: Auto Increment in InnoDB List-Archive: http://lists.mysql.com/mysql/221377 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e644ded6268ddc0484d162d7 --0016e644ded6268ddc0484d162d7 Content-Type: text/plain; charset=ISO-8859-1 Kudos for managing to drag up such an obscure piece of functionality :-) I can see where it would be useful, though. As to your question, though: given that that page indicates that it will reuse deleted sequence numbers, I think your best bet would be select @id := count(*)+1 from table where cluster='clusterA' AND file='fileA' ; - should be slightly faster than a max(), I think. That in a trigger on your table should emulate the behaviour pretty closely. Am I mistaken, or does your code try to start from sequence 0 ? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0016e644ded6268ddc0484d162d7--