Update With Inner Join Update Innter Join Mysql

  • November 5, 2023
  • -
UPDATE t1
LEFT JOIN
t2
ON t2.id = t1.id
SET t1.col1 = newvalue
WHERE t2.id IS NULL
  • General
Previous Post
Next Post