, 2004 9:49 AM
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: RE: Determining if query will work
I can't tell you how *glad* I am to get this running! Big hugs to you,
Shawn!
It's running beautifully. My only question is, after I run the queries,
I notice it won't let me create the temporary table again
Well that wasn't a very nice thing to say.
On Mon, 2004-10-25 at 11:56, none none wrote:
Like so many other people..
No one puts any collective thought into what they are doing..
Instead of moving on and trying to finish the rest yourself, you rely
on someone else to finish it for you.
I can't tell you how *glad* I am to get this running! Big hugs to you,
Shawn!
It's running beautifully. My only question is, after I run the queries,
I notice it won't let me create the temporary table again (saying
'tmpCandidates' already exists). Do I just need to then log out of my
client
I am so happy to get you working. Hopefully we helped some other along the
way ,too :-)
It's a good idea when working with data that you should always clean up
after yourself, regardless of what language you are using. Not only does
it free up resources faster it helps to make sure that you
like 'sappy' when what I really want is just
'sap', nothing preceeding and nothing following?
Thanks,
Eve
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:54 PM
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: RE: Determining if query will work
, October 20, 2004 3:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Determining if query will work
SELECT *
FROM wow.resume r
INNER JOIN wow.candidate c
ON c.Candidate_ID = r.Candidate_ID
WHERE r.Section_ID = '1'
AND MATCH (r.Section_Value) AGAINST
I would simplify this search by breaking the query into two steps, just as
you described. First locate all of the resumes where section 1 contains
the bit of text you are looking for then use those results to get the full
resume (all 6 sections)
There are 3 ways to do this. One is a
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Determining if query will work
I would simplify this search by breaking the query into two steps, just
as
you described. First locate all of the resumes where section 1 contains
the bit of text you are looking for then use those results to get
I think we're on to something. I've got one table importing data
correctly, resume to resume_erp. However, 'candidate' to 'candidate_erp'
appears goofy. I get the following error:
[mysql.loosefoot.com] ERROR 1062: Duplicate entry '1185' for key 1
With the following queries, query 3 being the
What is the definition of resume_erp (what is the result of: SHOW CREATE
TABLE resume_erp) ? What that error is telling you is that you are
attempting to add a record that matches a set of conditions that you said
could only exist once on the entire table (either your primary key or a
unique
What is the definition of resume_erp (what is the result of: SHOW
CREATE
TABLE resume_erp) ? What that error is telling you is that you are
Glad you added more info, or I would have been asking you, 'what do you
mean by definition?' :)
CREATE TABLE `resume_erp` (
`Candidate_ID` int(10) NOT
First a bit of friendly advice:
When performing an INSERT...SELECT... it is better to explicitly list the
source columns (part of the SELECT statement). Doing so will ensure that
if you re-order some columns or if you add/drop columns to/from one of the
tables participating in the SELECT
Based on Shawn's tips, I revised the query to read thusly:
SELECT *
FROM wow.resume r
INNER JOIN wow.candidate c
ON c.Candidate_ID = r.Candidate_ID
WHERE r.Section_ID = '1'
AND MATCH (r.Section_Value) AGAINST ('+peoplesoft' IN BOOLEAN
MODE);
INSERT INTO wow.resume_erp
See embedded comments
Eve Atley [EMAIL PROTECTED] wrote on 10/20/2004 03:33:41 PM:
Based on Shawn's tips, I revised the query to read thusly:
SELECT *
FROM wow.resume r
INNER JOIN wow.candidate c
ON c.Candidate_ID = r.Candidate_ID
WHERE r.Section_ID = '1'
14 matches
Mail list logo