|
|
| jc-Atl 2005-10-02, 9:56 pm |
| I'm trying to update the recruiterDB_extraNotes.recruiter_id to set it equal
to the corresponding value in recruiterDB_candidates. But I keep getting
errors when I try this in phpMyAdmin. Can anyone help ?
UPDATE `recruiterDB_extraNotes` SET `recruiterDB_extraNotes`.`recruiter_id`
= `recruiterDB_candidates`.`recruiter_id` WHERE
`recruiterDB_extraNotes`.`candidate_id` =
`recruiterDB_candidates`.`candidate_id`
Thanks !
| |
| Stefan Rybacki 2005-10-03, 7:56 am |
| jc-Atl wrote:
> I'm trying to update the recruiterDB_extraNotes.recruiter_id to set it equal
> to the corresponding value in recruiterDB_candidates. But I keep getting
> errors when I try this in phpMyAdmin. Can anyone help ?
>
> UPDATE `recruiterDB_extraNotes` SET `recruiterDB_extraNotes`.`recruiter_id`
> = `recruiterDB_candidates`.`recruiter_id` WHERE
> `recruiterDB_extraNotes`.`candidate_id` =
> `recruiterDB_candidates`.`candidate_id`
>
> Thanks !
>
>
Error message?
Stefan
| |
| Hilarion 2005-10-03, 6:57 pm |
| > I'm trying to update the recruiterDB_extraNotes.recruiter_id to set it equal
> to the corresponding value in recruiterDB_candidates. But I keep getting
> errors when I try this in phpMyAdmin. Can anyone help ?
>
> UPDATE `recruiterDB_extraNotes` SET `recruiterDB_extraNotes`.`recruiter_id`
> = `recruiterDB_candidates`.`recruiter_id` WHERE
> `recruiterDB_extraNotes`.`candidate_id` =
> `recruiterDB_candidates`.`candidate_id`
What DBMS are you using? MySQL? It should work for MySQL 4.0.4 or newer:
UPDATE recruiterDB_extraNotes, recruiterDB_candidates
SET recruiterDB_extraNotes.recruiter_id = recruiterDB_candidates.recruiter_id
WHERE recruiterDB_extraNotes.candidate_id = recruiterDB_candidates.candidate_id
Hilarion
|
|
|
|