[Bug] update join 提示语法错误

[bluestar1993]

Search before asking

• I had searched in the issues and found no similar issues.

Version

5.7.37

What's Wrong?

一个正常的update语句，执行提示我在联表时错误。

update a inner join b on a.id=b.id set a.`name`=b.`name`

报错:

> 1105 - errCode = 2, detailMessage = Syntax error in line 2:
inner join  a on a.id=b.id
^
Encountered: INNER
Expected

> 时间: 0s

What You Expected?

期望能给出解决方案，或者替代方案。

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[stalary]

You can use insert into select * from a join b replace it.