mysql two table association query and update Posted on July 24, 2022July 24, 2022 by ledUPDATE user1 a,user b SET a.name=b.name WHERE a.code = b.code