MySQL Bugs: #28592: Multi-column Updates Using Row Constructors and Row Subqueries

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:	None
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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);

Thank you for a reasonable feature request.