arcnlv
表注释: Table 'mysql.arcnlv' doesn't exist in engine
bxlyey
表注释: Table 'mysql.bxlyey' doesn't exist in engine
columns_priv
表注释: Column privileges
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
Host (主键) | char(60) | 否 | | |
|
|
Db (主键) | char(64) | 否 | | SCHEMATA -> SCHEMA_NAME |
|
|
User (主键) | char(80) | 否 | | |
|
|
Table_name (主键) | char(64) | 否 | | |
|
|
Column_name (主键) | char(64) | 否 | | |
|
|
Timestamp | timestamp | 否 | CURRENT_TIMESTAMP | |
|
|
Column_priv | set('Select', 'Insert', 'Update', 'References') | 否 | | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | Host | | A | 否 | |
Db | | A | 否 |
User | | A | 否 |
Table_name | | A | 否 |
Column_name | 0 | A | 否 |
duzefz
表注释: Table 'mysql.duzefz' doesn't exist in engine
enibag32
表注释: Table 'mysql.enibag32' doesn't exist in engine
func
表注释: User defined functions
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
name (主键) | char(64) | 否 | | |
|
|
ret | tinyint(1) | 否 | 0 | |
|
|
dl | char(128) | 否 | | |
|
|
type | enum('function', 'aggregate') | 否 | | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | name | 0 | A | 否 | |
gtid_slave_pos
表注释: Table 'mysql.gtid_slave_pos' doesn't exist in engine
gzywhk
表注释: Table 'mysql.gzywhk' doesn't exist in engine
help_relation
表注释: keyword-topic relation
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
help_topic_id (主键) | int(10) | 否 | | help_topic -> help_topic_id |
|
|
help_keyword_id (主键) | int(10) | 否 | | help_keyword -> help_keyword_id |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | help_keyword_id | | A | 否 | |
help_topic_id | 0 | A | 否 |
help_topic
表注释: help topics
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
help_topic_id (主键) | int(10) | 否 | | |
|
|
name | char(64) | 否 | | |
|
|
help_category_id | smallint(5) | 否 | | help_category -> help_category_id |
|
|
description | text | 否 | | |
|
|
example | text | 否 | | |
|
|
url | text | 否 | | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | help_topic_id | 0 | A | 否 | |
name | BTREE | 是 | 否 | name | 0 | A | 否 | |
hiebqy32
表注释: Table 'mysql.hiebqy32' doesn't exist in engine
host
表注释: Host privileges; Merged with database privileges
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
Host (主键) | char(60) | 否 | | |
|
|
Db (主键) | char(64) | 否 | | |
|
|
Select_priv | enum('N', 'Y') | 否 | N | |
|
|
Insert_priv | enum('N', 'Y') | 否 | N | |
|
|
Update_priv | enum('N', 'Y') | 否 | N | |
|
|
Delete_priv | enum('N', 'Y') | 否 | N | |
|
|
Create_priv | enum('N', 'Y') | 否 | N | |
|
|
Drop_priv | enum('N', 'Y') | 否 | N | |
|
|
Grant_priv | enum('N', 'Y') | 否 | N | |
|
|
References_priv | enum('N', 'Y') | 否 | N | |
|
|
Index_priv | enum('N', 'Y') | 否 | N | |
|
|
Alter_priv | enum('N', 'Y') | 否 | N | |
|
|
Create_tmp_table_priv | enum('N', 'Y') | 否 | N | |
|
|
Lock_tables_priv | enum('N', 'Y') | 否 | N | |
|
|
Create_view_priv | enum('N', 'Y') | 否 | N | |
|
|
Show_view_priv | enum('N', 'Y') | 否 | N | |
|
|
Create_routine_priv | enum('N', 'Y') | 否 | N | |
|
|
Alter_routine_priv | enum('N', 'Y') | 否 | N | |
|
|
Execute_priv | enum('N', 'Y') | 否 | N | |
|
|
Trigger_priv | enum('N', 'Y') | 否 | N | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | Host | | A | 否 | |
Db | 0 | A | 否 |
ibgvpl
表注释: Table 'mysql.ibgvpl' doesn't exist in engine
innodb_index_stats
表注释: Table 'mysql.innodb_index_stats' doesn't exist in engine
itmvwa
表注释: Table 'mysql.itmvwa' doesn't exist in engine
jbcwyb32
表注释: Table 'mysql.jbcwyb32' doesn't exist in engine
kzipot32
表注释: Table 'mysql.kzipot32' doesn't exist in engine
pbzzlo
表注释: Table 'mysql.pbzzlo' doesn't exist in engine
proc
表注释: Stored Procedures
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
db (主键) | char(64) | 否 | | SCHEMATA -> SCHEMA_NAME |
|
|
name (主键) | char(64) | 否 | | |
|
|
type (主键) | enum('FUNCTION', 'PROCEDURE') | 否 | | |
|
|
specific_name | char(64) | 否 | | |
|
|
language | enum('SQL') | 否 | SQL | |
|
|
sql_data_access | enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA') | 否 | CONTAINS_SQL | |
|
|
security_type | enum('INVOKER', 'DEFINER') | 否 | DEFINER | |
|
|
param_list | blob | 否 | | |
|
|
returns | longblob | 否 | | |
|
|
body | longblob | 否 | | |
|
|
definer | char(141) | 否 | | |
|
|
created | timestamp | 否 | CURRENT_TIMESTAMP | |
|
|
modified | timestamp | 否 | 0000-00-00 00:00:00 | |
|
|
sql_mode | set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH') | 否 | | |
|
|
character_set_client | char(32) | 是 | NULL | CHARACTER_SETS -> CHARACTER_SET_NAME |
|
|
body_utf8 | longblob | 是 | NULL | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | db | | A | 否 | |
name | | A | 否 |
type | 0 | A | 否 |
character_set_client | BTREE | 否 | 否 | character_set_client | | A | 是 | |
security_type | BTREE | 否 | 否 | security_type | | A | 否 | |
proxies_priv
表注释: User proxy privileges
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
Host (主键) | char(60) | 否 | | |
|
|
User (主键) | char(80) | 否 | | |
|
|
Proxied_host (主键) | char(60) | 否 | | |
|
|
Proxied_user (主键) | char(80) | 否 | | |
|
|
With_grant | tinyint(1) | 否 | 0 | |
|
|
Grantor | char(141) | 否 | | |
|
|
Timestamp | timestamp | 否 | CURRENT_TIMESTAMP | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | Host | | A | 否 | |
User | | A | 否 |
Proxied_host | | A | 否 |
Proxied_user | 1 | A | 否 |
Grantor | BTREE | 否 | 否 | Grantor | 0 | A | 否 | |
pttzqm
表注释: Table 'mysql.pttzqm' doesn't exist in engine
pvrley32
表注释: Table 'mysql.pvrley32' doesn't exist in engine
qcvgpk32
表注释: Table 'mysql.qcvgpk32' doesn't exist in engine
qveazc
表注释: Table 'mysql.qveazc' doesn't exist in engine
qxwqil32
表注释: Table 'mysql.qxwqil32' doesn't exist in engine
table_stats
表注释: Statistics on Tables
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
db_name (主键) | varchar(64) | 否 | | |
|
|
table_name (主键) | varchar(64) | 否 | | |
|
|
cardinality | bigint(21) | 是 | NULL | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | db_name | | A | 否 | |
table_name | 0 | A | 否 |
tibcag32
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
data | longblob | 是 | NULL | |
|
|
time_zone_leap_second
表注释: Leap seconds information for time zones
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
Transition_time (主键) | bigint(20) | 否 | | |
|
|
Correction | int(11) | 否 | | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | Transition_time | 0 | A | 否 | |
time_zone_transition_type
表注释: Time zone transition types
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
Time_zone_id (主键) | int(10) | 否 | | time_zone -> Time_zone_id |
|
|
Transition_type_id (主键) | int(10) | 否 | | |
|
|
Offset | int(11) | 否 | 0 | |
|
|
Is_DST | tinyint(3) | 否 | 0 | |
|
|
Abbreviation | char(8) | 否 | | |
|
|
索引
没有已定义的索引!
键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
---|
PRIMARY | BTREE | 是 | 否 | Time_zone_id | | A | 否 | |
Transition_type_id | 0 | A | 否 |
tkzyuy32
表注释: Table 'mysql.tkzyuy32' doesn't exist in engine
uavtnh
表注释: Table 'mysql.uavtnh' doesn't exist in engine
wbasjs32
表注释: Table 'mysql.wbasjs32' doesn't exist in engine
whddxj
表注释: Table 'mysql.whddxj' doesn't exist in engine
xqwjid32
表注释: Table 'mysql.xqwjid32' doesn't exist in engine
yczjgq32
表注释: Table 'mysql.yczjgq32' doesn't exist in engine
yuvrsp32
表注释: Table 'mysql.yuvrsp32' doesn't exist in engine
yxcpsl32
表注释: Table 'mysql.yxcpsl32' doesn't exist in engine
yzkrkl
字段 | 类型 | 空 | 默认 | 链接到 |
注释 |
MIME |
---|
data | longblob | 是 | NULL | |
|
|
zkyeek
表注释: Table 'mysql.zkyeek' doesn't exist in engine
zsxleh
表注释: Table 'mysql.zsxleh' doesn't exist in engine