Posted by Hilarion on 10/11/56 11:28

> > > 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
>
> Thanks! That did it! I was leaving out the "recruiterDB_candidates" in the
> UPDATE part of the statement.
> But why do I have to include it, since I was only updating
> recruiterDB_extraNotes ?

You have to specify a list of tables including the tables which are updated,
but also the tables which are the source of data. Something like "FROM" clause
in "SELECT" statement. Different DBMSes do it different way (different
syntax and restrictions). MySQL has it this way.


Hilarion

[Back to original message]