List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 28 2004 7:19pm
Subject:Re: Multiple Insert Statement?
View as plain text  
At 14:16 -0400 9/28/04, Eve Atley wrote:
>My query:
>SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID =
>'1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND
>c.Candidate_ID = r.Candidate_ID;
>
>Is it possible to do a multiple insert statement like so?

No.

>
>INSERT INTO wow.candidate_erp
>(Candidate_ID, Section_ID, Section_Value)
>INSERT INTO wow.resume_erp
>(Candidate_ID, Vendor_ID, etc.)
>SELECT SQL_CALC_FOUND_ROWS *
>FROM wow.resume r
>INNER JOIN wow.candidate c;
>
>Or do I have to break out the INSERT statements seperately?

Yes.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
ImagesGH28 Sep
  • Re: ImagesEric Bergen28 Sep
  • Re: ImagesJigal van Hemert28 Sep
    • Re: ImagesDreamWerx28 Sep
      • Re: ImagesGH28 Sep
        • Re: ImagesDreamWerx28 Sep
          • RE: ImagesEd Lazor28 Sep
RE: Imagesjabbott28 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesEric Bergen28 Sep
  • RE: ImagesEd Lazor28 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesDreamWerx28 Sep
  • RE: ImagesEd Lazor28 Sep
  • Multiple Insert Statement?Eve Atley28 Sep
    • Re: Multiple Insert Statement?GH28 Sep
      • Re: Multiple Insert Statement?SGreen28 Sep
    • Re: Multiple Insert Statement?Paul DuBois28 Sep
      • RE: Multiple Insert Statement?Eve Atley28 Sep
        • RE: Multiple Insert Statement?mos28 Sep
        • Re: Multiple Insert Statement?Rhino28 Sep
        • Re: Multiple Insert Statement?Rhino29 Sep
  • RE: ImagesEd Lazor28 Sep
Re: ImagesDreamWerx28 Sep
  • Re: ImagesGH28 Sep
    • Re: ImagesDreamWerx28 Sep
Re: ImagesDreamWerx28 Sep
Re: ImagesGH28 Sep
Re: ImagesDreamWerx28 Sep