Multiple Statements in a query
- From: "paladin.rithe@xxxxxxxxx" <paladin.rithe@xxxxxxxxx>
- Date: 2 Mar 2007 11:28:02 -0800
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?
.
- Follow-Ups:
- Re: Multiple Statements in a query
- From: Dikkie Dik
- Re: Multiple Statements in a query
- From: Ivan Marsh
- Re: Multiple Statements in a query
- Prev by Date: When to flock
- Next by Date: Re: Multiple Statements in a query
- Previous by thread: When to flock
- Next by thread: Re: Multiple Statements in a query
- Index(es):