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

Mass Insert using Except

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 10, rows affected: 9, absolute service time: 0,22 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 permission record test1 test2 test3
1 deer _SuperUser 99 test1 test2 test3
2 dingo _SuperUser 99 test1 test2 test3
3 dog _SuperUser 99 test1 test2 test3