MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: How do I combine 3 queries into one
Posted by: Rick James
Date: April 12, 2009 11:49PM

How about 1 INSERT (followed by getting the inserted id -- in a separate statement), then 2 UPDATEs.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How do I combine 3 queries into one
Neil Jensen
April 12, 2009 07:37PM
Re: How do I combine 3 queries into one
Peter Brawley
April 12, 2009 08:21PM
Re: How do I combine 3 queries into one
Neil Jensen
April 12, 2009 09:01PM
Re: How do I combine 3 queries into one
Neil Jensen
April 12, 2009 09:51PM
Re: How do I combine 3 queries into one
Rick James
April 12, 2009 11:49PM
Re: How do I combine 3 queries into one
Neil Jensen
April 13, 2009 12:12PM
Re: How do I combine 3 queries into one
Rick James
April 13, 2009 07:12PM
Re: How do I combine 3 queries into one
Neil Jensen
April 13, 2009 07:50PM
Re: How do I combine 3 queries into one
Rick James
April 13, 2009 10:26PM
Re: How do I combine 3 queries into one
Neil Jensen
April 14, 2009 02:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.