single set clause..

[Lias]

Hello all,
I'm looking for a feature whereby multiple columns can be updated with a single SET clause such as:
UPDATE tab1 SET (col1, col2, col3) = (SELECT col4, col5, col6 FROM tab2 WHERE tab2.col1 = tab1.col1);
I don't find this feature documented for MySQL. How to accomplish it, any idea?
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[evy]

UPDATE tab1 AS t1
JOIN tab2 AS t2 ON tab1.col1 = tab2.col1
SET t1.col1 = t2.col4,
t1.col2 = t2.col5,
t1.col3 = t2.col6; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --