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 | ||
---|---|---|
• Images | GH | 28 Sep |
• Re: Images | Eric Bergen | 28 Sep |
• Re: Images | Jigal van Hemert | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | GH | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• RE: Images | jabbott | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Re: Images | Eric Bergen | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Multiple Insert Statement? | Eve Atley | 28 Sep |
• Re: Multiple Insert Statement? | GH | 28 Sep |
• Re: Multiple Insert Statement? | SGreen | 28 Sep |
• Re: Multiple Insert Statement? | Paul DuBois | 28 Sep |
• RE: Multiple Insert Statement? | Eve Atley | 28 Sep |
• RE: Multiple Insert Statement? | mos | 28 Sep |
• Re: Multiple Insert Statement? | Rhino | 28 Sep |
• Re: Multiple Insert Statement? | Rhino | 29 Sep |
• RE: Images | Ed Lazor | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | GH | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |
• Re: Images | GH | 28 Sep |
• Re: Images | DreamWerx | 28 Sep |