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

How to create Merge SQL when with duplicated data

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 7, rows affected: 14, absolute service time: 0,28 sec, absolute service time: 0,28 sec 
edit mode |  history
   $action ID Load ID Load
1 UPDATE 1 1 1 111
2 UPDATE 3 3 3 444
3 UPDATE 3 3 3 444
4 INSERT NULL NULL 6 666
   ID Load
1 1 111
2 2 2
3 3 444
4 3 444
5 4 4
6 5 5
7 6 666