mysql联合更新

        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}
posted @ 2023-08-25 15:22  qing222  阅读(6)  评论(0编辑  收藏  举报