Guest User

Untitled

a guest
Jul 22nd, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. create table table1
  2. (
  3. id int,
  4. date1 date,
  5. date2 date,
  6. status int
  7. );
  8.  
  9. insert into table1 (id,date1,date2,status) values
  10. (123, '2018-07-01','2018-07-20',0),
  11. (124, '2018-07-07',null,0)
  12.  
  13. select * from table1
  14.  
  15. UPDATE table1
  16. SET
  17. date1 = IF(date2 is null,date1,date2),
  18. date2 = NULL, status = 1
  19. WHERE id IN (123,124,125)
  20.  
  21. UPDATE table1
  22. SET
  23. date1 = IF(date2 is null,date1,date2),
  24. date2 = NULL, status = 1
  25. WHERE id IN (123,124,125)
  26.  
  27. select * from table1
Add Comment
Please, Sign In to add comment