UPDATE with JOIN generates invalid query for MySQL

[overflowz]

the following query:

await db.updateTable("tableA")
  .innerJoin("tableB", "tableB.id", "tableA.tableB_id")
  .set({ foo: 1 })
  .where("tableB.field", "=", 1)
  .execute();

generates following SQL:

update tableA
set foo = 1
inner join tableB on tableB.id = tableA.tableB_id
where tableB.field = 1

while correct syntax (for MySQL) should be:

update tableA
inner join tableB on tableB.id = tableA.tableB_id -- <-- order of these swapped
set foo = 1                                       -- <-- order of these swapped
where tableB.field = 1

tested with latest Kysely version (0.27.4) and using MySQL driver.

[overflowz]

woops, duplicate of #192 (was searching for UPDATE with JOIN)