Re: Deadlock problem
From: <paul.vernon_at_ukk.ibmm.comm>
Date: Mon, 18 Mar 2002 14:32:26 +0000
Message-ID: <a74u94$i00$1_at_sp15at20.hursley.ibm.com>
Date: Mon, 18 Mar 2002 14:32:26 +0000
Message-ID: <a74u94$i00$1_at_sp15at20.hursley.ibm.com>
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