val schreef:
> On 1 mai, 00:20, Luuk <L...@invalid.lan> wrote:
>> time to study this page a bit more...http://dev.mysql.com/doc/refman/5.0/en/update.html
>>
>
> Wonderful link !
>
> from Rafi B, on this page :
>
> UPDATE jobs AS toTable, jobs AS fromTable
> SET
> toTable.job_type_id = fromTable.job_type_id,
> toTable.job_company_id = fromTable.job_company_id,
> toTable.job_source = fromTable.job_source,
> WHERE
> (toTable.job_id = 6)
> AND
> (fromTable.job_id = 1)
>
> Exactly what I was looking for.
> This page is like a collection of tricks, perfect for a beginner like
> me.
>

no, this is NOT a collection of tricks,
this is the MANUAL... ;-)

> Thanks !
>
> val


--
Luuk