Bug #28592 Multi-column Updates Using Row Constructors and Row Subqueries
Submitted: 22 May 2007 13:16 Modified: 24 May 2007 6:14
Reporter: Mark Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: row constructor, row constructors, row subqueries, row subquery, UPDATE

[22 May 2007 13:16] Mark
The ability to do updates using row subqueries would be very convenient. 

How to repeat:
e.g. update t set (f1,f2,f3) = (select g1,g2,g3 from s where t.f4 = s.g4);
[24 May 2007 6:14] Valeriy Kravchuk
Thank you for a reasonable feature request.