Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

MERGE with DELETE on target with partial match on source?

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 5, rows affected: 11, absolute service time: 0,19 sec 
edit mode |  history
   $action fooId barId status lastModified fooId barId status lastModified
1 INSERT 1 2 INACTIVE 06.09.2017 16:31:23 NULL NULL NULL NULL
2 UPDATE 1 1 ACTIVE 06.09.2017 16:31:23 1 1 ACTIVE 06.09.2017 16:31:23
3 DELETE NULL NULL NULL NULL 1 3 INACTIVE 06.09.2017 16:31:23
   fooId barId status lastModified
1 1 1 ACTIVE 06.09.2017 16:31:23
2 2 1 ACTIVE 06.09.2017 16:31:23
3 2 2 INACTIVE 06.09.2017 16:31:23
4 1 2 INACTIVE 06.09.2017 16:31:23

    
                
λ
.NET NoSQL database for rapid development