MERGE into （用法笔记）

 MERGE INTO trackedVehicleBus t

    USING (SELECT tt.* FROM trackedVehicleBus tt WHERE tt.tracktype = 2) tw

    ON (t.tracktype = tw.tracktype)

    WHEN MATCHED THEN

      UPDATE SET t.rolename = 'upad3te'

    WHEN NOT MATCHED THEN

      INSERT

      VALUES

        ('11', '22', 'insert', 'a$f$fG$ff', 1, '02:00', '05:00', 2);

    

    MERGE INTO trackedVehicleBus t

    USING (select count(*) co

             from trackedVehicleBus bs

            where bs.tracktype = 2) tw

    ON (tw.co <> 0)

    WHEN MATCHED THEN

      UPDATE SET t.rolename = 'upad3te'

    WHEN NOT MATCHED THEN

      INSERT

      VALUES

        ('11', '22', 'insert', 'a$f$fG$ff', 1, '02:00', '05:00', 2);