Re: Multiple Insert Statement?

[GH]

I know that this is off topic and such... but can you explain the
Match / Against that you used in your query? i have never seen syntax
like that in SQL


On Tue, 28 Sep 2004 14:16:56 -0400, Eve Atley <eatley@stripped> 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?
> 
> 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?
> 
> Thanks!
> - Eve
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
>