MySQL 相当于 MATCH 上的 MERGE

Question

我有以下 MS SQL 查询:

    MERGE drivessold as T USING specs as S ON
    drivessold.SKU = specs.SKU_num
    WHEN MATCHED THEN
    UPDATE SET 
    drivessold.color = specs.color, 
    drivessold.speed = specs.speed;

如何在 mySQL 中执行类似的查询？

注意:SKU 和 SKU_num 不是表中的键(这是唯一的)。

Answer 1

在 mysql 中，您需要加入才能执行此操作

UPDATE drivessold 
JOIN specs ON drivessold.SKU = specs.SKU_num
SET drivessold.color = specs.color, 
drivessold.speed = specs.speed;