Open
Description
Dialect
MySQL
Failing SQL
UPDATE foo
JOIN bar
SET foo.b = 42
WHERE bar.a = 1;
Description
MySQL supports a join everywhere its syntax uses tables_references
.
https://dev.mysql.com/doc/refman/8.0/en/update.html
MySQL
UPDATE foo
JOIN bar
SET foo.b = 42
WHERE bar.a = 1;
MySQL supports a join everywhere its syntax uses tables_references
.
https://dev.mysql.com/doc/refman/8.0/en/update.html