Uriel Wittenberg writes:
UPDATE persondata SET age = select age from othertable where
persondata.id = othertable.id;
But the manual gives no clue as to whether this is possible.
It does. If you look at the documentation for UPDATE, you'll
find no mention of multi-table updates, and so they don't
exist. If you search the docs you'll find that they are to
be added in 4.1.
The FAQ clearly states that multi-table updates and deletes
do not exist at this point in time. And imagine how much less
traffic there'd be on this list if everyone read the FAQ
before posting.
//C - amazed that the some questions pop up almost every week.
11 messages in com.mysql.lists.mysqlRe: Where UPDATE documentation?
