NO! That is really, really not thread safe! Imagine what happens when 2 ppl do inserts at the same time...
[insert #1][insert #2][query #1][query #2] Both [query #1] and [query #2] return the same id. Ooops! kaboom! Larry On 8/17/05, Alan Hicks <[EMAIL PROTECTED]> wrote: > Hi Brian, > > I had the same problem and could not find any working examples. Finally I > stumbled upon > the query where 'userId' is an auto-generated key in my mysql table. If > you replace the > query you have with this one you should be in business. > > > SELECT MAX(userId) FROM tb_user > > > Hope this helps. > > Alan. > > > > On Wed, 17 Aug 2005 21:43:05 +0100, Barnett, Brian W. > <[EMAIL PROTECTED]> wrote: > > > We've been using SQL Server and are moving to mySQL. Can somebody tell me > > how to do this for mySql: > > > > <selectKey resultClass="int" keyProperty="id"> > > SELECT @@IDENTITY AS id > > </selectKey> > > > > TIA, > > Brian Barnett > > > > **************************************************************************** > > This email may contain confidential material. > > If you were not an intended recipient, > > Please notify the sender and delete all copies. > > We may monitor email to and from our network. > > **************************************************************************** > > > > > > > > > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ >
