|
|
Posted by Ivan Marsh on 03/02/07 19:51
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.
Navigation:
[Reply to this message]
|