Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. replace into table name (..some columns..) values (..some values.. ,
  2.  
  3. IF(creation_time is null, STR_TO_DATE('2017/02/21 18:25:51', '%Y-%m-%d %H:%i:%s'), '')
  4.  
  5. SET creation_time = CASE
  6. WHEN creation_time is null THEN STR_TO_DATE('2022-02-20 15:40:58', '%Y-%m-%d %H:%i:%s')
  7. ELSE NULL
  8. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement