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

Update using a temp table

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 12, rows affected: 10, absolute service time: 0,2 sec 
edit mode |  history  | discussion
   animal legs colour
1 cat 4 red
2 bird 2 yellow
3 dog 4 red
4 deer 4 red
5 fish 0 blue
6 dingo 4 yellow
   animal legs colour
1 cat 4 red
2 bird 2 yellow
3 dog 1 red
4 deer 4 red
5 fish 10 blue
6 dingo 4 yellow

    
                
Advertise here.