MySQL中update…inner join… 语法 UPDATE bill_down_detail_pre a INNER JOIN bill_down_pre b ON a.bill_down_id = b.id SET a.settlement_cycle_id = b.settlement_cycle_id;