Re: Deadlock problem

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 - 08:32:26 CST