MySQL 查询结果作为更新内容

    UPDATE t_goodinfo y,
     (
        SELECT
            a.id,
            a.wharehousing_project_id,
            a.settlement_type,
            a.material_id,
            a.material_name,
            b.material_name AS result
        FROM
            t_goodinfo a
        LEFT JOIN t_material b ON a.material_id = b.id
        AND b. STATUS = 0
        WHERE
            a. STATUS = 0 
            -- AND a.id = '1231429194043138048'
    ) x
    SET y.material_name = x.result
    WHERE
        y.id = x.id