Re: why UPDATE requires share lock(S) for table joined

[Rick James]

Shared lock is weaker than Xclusive lock.

Let's see SHOW CREATE TABLE for each table.

And...

EXPLAIN 
SELECT  *
    FROM  t
    inner join  lktest on lktest.c3=t.x
    where  lktest.c3=2;