Posted by Jerry Stuckle on 03/03/07 13:50

Ivan Marsh wrote:
> On Fri, 02 Mar 2007 11:28:02 -0800, paladin.rithe@gmail.com wrote:
>
>> I have 2 statements that I'd like to string together in a query, but
>> according to everything I'm seeing, it's not possible.
>> What I'm doing is an insert of a row, where the primary key is an auto
>> increment. I want to retrieve that by using LAST_INSERT_ID(). I
>> tried sending another query after the first (once I knew that it the
>> data was what I need) but it didn't return anything. It seems that
>> that function can't be used in separate calls or something. Either
>> that or there's a setting that I need to check. Any ideas?
>
> If you're trying to return the last inserted row on a table with an auto
> increment field all you have to do is query the maximum value in that
> field.
>

And if you have two people insert at the same time one is going to get
the wrong value.

A terrible way to do it!

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]