I want to copy rows of data from a query result to another table. How do I
accomplish this? Here's my example for further explanation...
I have 2 tables, candidate and resume. I have 2 other (currently empty)
tables, exact duplicates, candidate_erp and resume_erp. In resume_erp will
be duplicates from resume that contain 'ERP' (Enterprise Resource Planning)
keywords, ie. BAAN, SAP, Peoplesoft, and more. In candidate_erp will be the
associated 'candidate' rows. When I construct my SQL query and run it, I can
successfully view the resulting query which contain the keyword BAAN. How
can I then copy those results into candidate_erp?
A query example...
SELECT SQL_CALC_FOUND_ROWS *
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
I notice that MySQL CC and MySQL Query Browser both have the ability to
export to a file (ie. CSV), but it doesn't appear they will import neatly
into the tables candidate_erp and resume_erp.
Thanks in advance,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
