Does update inner join add table-level locks?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: update inner join 会加表级别的锁吗?

| username: Running

Two different SQL statements both perform batch updates with INNER JOIN net_nasipschool b. When executed simultaneously, table locking occurs. Isn’t this a row-level lock? Are there any optimization solutions?

| username: tidb菜鸟一只 | Original post link

It won’t add table-level locks, but the rows in table A that meet the join conditions will be locked.