time_zone_transition

• 该表提供查询时区的跳秒数据
• 表结构定义

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Time zone transitions';

• 表字段含义

• Time_zone_id：时区ID
• Transition_time：与time_zone_leap_second表中的Transition_time字段含义相同
• Transition_type_id：与time_zone_transition_type表中的Transition_type_id相对应

• 表记录内容示例

root@localhost : mysql 04:59:54> select * from time_zone_transition limit 2;
+--------------+-----------------+--------------------+
| Time_zone_id | Transition_time | Transition_type_id |
+--------------+-----------------+--------------------+
| 1 | -1830383032 | 1 |
| 3 | -1640995148 | 2 |
+--------------+-----------------+--------------------+
2 rows in set (0.00 sec)

---

上一篇：time_zone_name表 |下一篇：time_zone_transition_type表