MySQL 4.0.18 - wie eine Tabelle mit anderer updaten?

[André Laugks]

Hallo!

UPDATE formsignaleverzeichnis f SET f.kuerzel=(SELECT d.kuerzel FROM formsignaleverzeichnis f, ds100 d WHERE f.ortsname = d.bsname AND d.dsart IN ('Bf','Bk'));

siehe dazu: http://dev.mysql.com/doc/refman/4.1/en/update.html
--------------------------------><8----------------------------
Starting with MySQL 4.0.4, you can also perform UPDATE operations covering multiple tables. The table_references clause lists the tables involved in the join. Its syntax is described in Section 13.2.7.1, “JOIN Syntax”. Here is an example:

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;
--------------------------------><8----------------------------

André Laugks