From: Johan De Meersman Date: April 22 2010 11:37am Subject: Re: Auto Increment in InnoDB List-Archive: http://lists.mysql.com/mysql/221381 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd489b8d666da0484d1bd30 --000e0cd489b8d666da0484d1bd30 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Apr 22, 2010 at 1:34 PM, Carsten Pedersen wrote: > Wouldn't that strategy cause problems if one or more rows have been > deleted in the meantime? (i.e. sequence numbers 1-4 have been created, row > 2 has been deleted - new sequence number would be 4). > Yeps. I'm none too sharp today, apparently. Max() it is. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --000e0cd489b8d666da0484d1bd30--