结合inner join更新表字段 update tableOne inner join tableTwo on tableOne.id=tableTwo.id set tableOne.date=tableTwo.date;