mybatis-dynamic-sql icon indicating copy to clipboard operation
mybatis-dynamic-sql copied to clipboard

Published 20 hours ago • verified publisher icon mybatis

Ability to perform merge update

Open reenimathew opened this issue 6 years ago • 1 comments

Is it possible to perform update by joining with another table? I don't see such a capability. Can someone help with this? I don't want to do sub query as I need to update multiple columns from other table.

UPDATE Products SET end_date = other.end_date FROM Products me JOIN #updates other ON (me.id = other.id)

reenimathew avatar May 17 '19 06:05 reenimathew