根据表B查找到的值作为更新表A的数据的条件
UPDATE `表A` SET `check`='yes',`updatetime`=now() WHERE `id` in (SELECT `mu_id` FROM `表B` WHERE `id` = 2)
根据表B查找到的值作为更新表A的数据的条件
UPDATE `表A` SET `check`='yes',`updatetime`=now() WHERE `id` in (SELECT `mu_id` FROM `表B` WHERE `id` = 2)