Re: Multiple Insert Statement?

[Paul DuBois]

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