原问题
update t set (a,b,c)=(select a,b,c from t where 条件1) where 条件2
解决
UPDATE books
INNER JOIN periodicals ON books.id = 1
AND periodicals.id = 1
SET books.bk_author = periodicals.pl_author,
books.bk_name = periodicals.pl_name
原问题
update t set (a,b,c)=(select a,b,c from t where 条件1) where 条件2
解决
UPDATE books
INNER JOIN periodicals ON books.id = 1
AND periodicals.id = 1
SET books.bk_author = periodicals.pl_author,
books.bk_name = periodicals.pl_name