Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. update floor set fk_building = 3 where fk_building != 3 and floor_id = 1;
  2.  
  3. select * from floor where fk_building != 3
  4.  
  5. update floor set fk_building = 3 where (not fk_building <=> 3) and floor_id = 1;
  6.  
  7. update floor set fk_building = 3 where (fk_building != 3 OR fk_building IS NULL) and floor_id = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement