All pages
Powered by GitBook
1 of 1

Loading...

mysql.time_zone_leap_second Table

The mysql.time_zone_leap_second table lists leap second corrections to be applied to specific time zones.

The mysql.time_zone_leap_second table is one of the mysql system tables that can contain time zone information. It is usually preferable for the system to handle the time zone, in which case the table will be empty (the default), but you can populate the mysql time zone tables using the mariadb-tzinfo-to-sql utility. See Time Zones for details.

This table uses the Aria storage engine.

The mysql.time_zone_leap_second table contains the following fields:

Field
Type
Null
Key
Default
Description

See Also

This page is licensed: CC BY-SA / Gnu FDL

Transition_time

bigint(20)

NO

PRI

NULL

Correction

int(11)

NO

NULL

mysql.time_zone table
mysql.time_zone_name table
mysql.time_zone_transition table
mysql.time_zone_transition_type table

System tables should not normally be edited directly. Use the related SQL statements instead.