time_zone_transition_type : Time_zone_transition_type : Data Dictionary MySQL TUTORIALS

MySQL TUTORIALS » Data Dictionary » Time_zone_transition_type »

time_zone_transition_type


mysql> desc time_zone_transition_type;
+--------------------+---------------------+------+-----+---------+-------+
| Field              | Type                | Null | Key | Default | Extra |
+--------------------+---------------------+------+-----+---------+-------+
| Time_zone_id       | int(10) unsigned    | NO   | PRI |         |       |
| Transition_type_id | int(10) unsigned    | NO   | PRI |         |       |
| Offset             | int(11)             | NO   |     | 0       |       |
| Is_DST             | tinyint(3) unsigned | NO   |     | 0       |       |
| Abbreviation       | char(8)             | NO   |     |         |       |
+--------------------+---------------------+------+-----+---------+-------+
5 rows in set (0.02 sec)

mysql> use test
Database changed