语法: MySQL: UPDATE a,b SET a.1=b.1 WHERE a.2=b.2 实例 update expense_voucher as ev,inventory as iv set ev.storage_time= iv.first_warehousing_time where ev.store_item_id = iv.id and ev.rksj is null 参考: 链接