mysql联合更新

Heng- / 2023-08-25 / 原文

        update railway r
        join railway_section rs on r.id = rs.railway_id
        join work_station ws on r.id = ws.railway_id
        join patroller p on r.id = p.railway_id
        set rs.railway_name = #{name},
            ws.railway_name = #{name},
            p.railway_name = #{name}
        where r.id = #{id}