Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- replace into table name (..some columns..) values (..some values.. ,
- IF(creation_time is null, STR_TO_DATE('2017/02/21 18:25:51', '%Y-%m-%d %H:%i:%s'), '')
- SET creation_time = CASE
- WHEN creation_time is null THEN STR_TO_DATE('2022-02-20 15:40:58', '%Y-%m-%d %H:%i:%s')
- ELSE NULL
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement