加时间
UPDATE t_cpzs_code SET production_time = ADDTIME(date('2018-11-01') + INTERVAL 3 HOUR, time(production_time)) WHERE equipment_name='15#'
同步时间
UPDATE customers SET created_time = UNIX_TIMESTAMP(created_at) WHERE id > 0
加时间
UPDATE t_cpzs_code SET production_time = ADDTIME(date('2018-11-01') + INTERVAL 3 HOUR, time(production_time)) WHERE equipment_name='15#'
同步时间
UPDATE customers SET created_time = UNIX_TIMESTAMP(created_at) WHERE id > 0