a guest Nov 9th, 2018 87 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- ALTER TABLE `event61_log` ADD `mission_start_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '任務開始時間';
- ALTER TABLE `event61_log` ADD INDEX (`mission_start_time`);
- UPDATE event61_log
- SET mission_start_time =
- WHEN create_time=1541621100 THEN '2018-11-08 04:00:01'
- WHEN create_time=1541707500 THEN '2018-11-09 04:00:01'
- ELSE from_unixtime(create_time)
RAW Paste Data