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 =
CASE
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)
END