update left join

[Ralf Narozny]

Patrick Bierans wrote:

>>from: "Ralf Narozny", subject: "Re: update left join"
>>    
>>
>
>  
>
>>In Linux shell I'd do:
>>
>>echo "SELECT concat('UPDATE bilder SET used = 0 WHERE id = ', id, ';') 
>>FROM bilder AS b LEFT JOIN artikel AS a ON (b.name = a.bildname) WHERE 
>>a.id IS NULL" | mysql -N -u <user> -p <dbname> | mysql -N -u <user> -p 
>><dbname>
>>
>>but without further details....
>>    
>>
>
>I'd like some really good MySql statements. No work-around.
>

You might want SQL statements, but it is simply impossible in MySQL ;-)

>
>Trotzdem Danke, Ralf ;)
>
>P. Bierans
>
>  
>

-- 
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:rnarozny_(at)_splendid.de, http://www.splendid.de



---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql