Re: Deadlock problem

From: <paul.vernon_at_ukk.ibmm.comm>
Date: Mon, 18 Mar 2002 14:32:26 +0000
Message-ID: <a74u94$i00$>

I suppose the simple answer is to do the insert in one op:

insert into mytable values ( (select max(id)+1 from mytable) ,data)

A bit of a pain if you want to know what id you just inserted was though. Received on Mon Mar 18 2002 - 15:32:26 CET

Original text of this message