[drupal-devel] Mysql problem

[puregin]

 From the MySQL manual:

Starting with MySQL 4.0.4, you can also perform UPDATE operations that 
cover multiple tables. The table_references part lists the tables 
involved in the join. Its syntax is described in Section 13.1.7.1, 
“JOIN Syntax”. Here is an example:

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;
The example shows an inner join using the comma operator, but 
multiple-table UPDATE statements can use any type of join allowed in 
SELECT statements, such as LEFT JOIN.

What version of MySQL are you running on, Gordon?


On 11 May 2005, at 10:39 PM, Gerhard Killesreiter wrote:

>
>
> On Thu, 12 May 2005, Gordon Heydon wrote:
>
>> db_query('UPDATE {ec_ad_team} at LEFT JOIN {ec_transaction} t ON
>> at.txnid = t.txnid SET at.did = %d WHERE t.workflow = %d and at.did =
>> 0', $did, 6);
>>
>> The problem is that for some reason the on my clients mysql server
>> doesn't seem to do the update, can anyone give me a reason why this
>> would be happening, and a possible method of resolving this.
>
> UPDATE does not support JOINs according to the mysql manual.
>
> Cheers,
> 	Gerhard
>

Djun