Server:CentOS Linux release 7.3.1611 (Core) (3.10.0-514.el7.x86_64)
GBase8a MPP Cluster:9.5.2.39-redhat7.3-x86_64
GBaseDataStudio:9.5.1.0_build2_Windows_x86_64
通过建表语句 获得备注信息
use gbase;
show create
table
time_zone_transition_type;
+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| time_zone_transition_type | CREATE TABLE "time_zone_transition_type" (
"Time_zone_id" int(10) unsigned NOT NULL,
"Transition_type_id" int(10) unsigned NOT NULL,
"Offset" int(11) NOT NULL DEFAULT '0',
"Is_DST" tinyint(3) unsigned NOT NULL DEFAULT '0',
"Abbreviation" char(8) NOT NULL DEFAULT ' ',
PRIMARY KEY ("Time_zone_id","Transition_type_id")
) ENGINE=GsSYS DEFAULT CHARSET=utf8mb4 COMMENT='Time zone transition types' |
+---------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
通过查看列 获得备注信息
show full columns
from
time_zone_transition_type;
+--------------------+---------------------+--------------------+------+-----+----------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+--------------------+---------------------+--------------------+------+-----+----------+-------+---------------------------------+---------+
| Time_zone_id | int(10) unsigned | NULL | NO | PRI | NULL | | select,insert,update,references | |
| Transition_type_id | int(10) unsigned | NULL | NO | PRI | NULL | | select,insert,update,references | |
| Offset | int(11) | NULL | NO | | 0 | | select,insert,update,references | |
| Is_DST | tinyint(3) unsigned | NULL | NO | | 0 | | select,insert,update,references | |
| Abbreviation | char(8) | utf8mb4_general_ci | NO | | | | select,insert,update,references | |
+--------------------+---------------------+--------------------+------+-----+----------+-------+---------------------------------+---------+
5 rows in set (Elapsed: 00:00:00.00)
相关链接
欢迎各位同学一起来交流学习心得!
最后修改时间:2021-12-16 18:14:10
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。