直接代码如下:
UPDATE tbl_datasource as a
INNER JOIN (
SELECT id
,jdbc_url
,username
,password
FROM tbl_datasource
where id = 36
) b
on 1 = 1
SET a.jdbc_url = b.jdbc_url
,a.username = b.username
,a.password = b.password
where a.id = 37
效果如下