mysql - 如何更新多行并从 Select 子查询中获取 MySQL 中的 where 值

Question

当我有来自同一 select 子查询的 where 条件值时，我想从 Select 更新 10000 行。例如

UPDATE TableA A 
SET col1 = @val1, col2 = @val2
WHERE col3 = @val3;
 All @val value I get from SELECT statement.
SELECT @val1, @val2, @val3 From TableB B
WHERE B.Key = (condition).  

Answer 1

试试这个:

UPDATE TableA A 
JOIN TableB B
ON B.val3 = A.col3
SET A.col1 = b.val1, 
    A.col2 = b.val2
WHERE B.Key = (condition)