SELECT * FROM `COLUMNS`
ORDER BY `COLUMNS`.`TABLE_NAME` ASC
过滤行: |
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME ![]() | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | performance_schema | accounts | USER | 1 | NULL | YES | char | 16 | 48 | NULL | NULL | NULL | utf8 | utf8_bin | char(16) | select,insert,update,references | ||||
def | performance_schema | accounts | HOST | 2 | NULL | YES | char | 60 | 180 | NULL | NULL | NULL | utf8 | utf8_bin | char(60) | select,insert,update,references | ||||
def | performance_schema | accounts | CURRENT_CONNECTIONS | 3 | NULL | NO | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | select,insert,update,references | ||||
def | performance_schema | accounts | TOTAL_CONNECTIONS | 4 | NULL | NO | bigint | NULL | NULL | 19 | 0 | NULL | NULL | NULL | bigint(20) | select,insert,update,references | ||||
def | information_schema | ALL_PLUGINS | PLUGIN_NAME | 1 | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_VERSION | 2 | NO | varchar | 20 | 60 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(20) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_STATUS | 3 | NO | varchar | 16 | 48 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(16) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_TYPE | 4 | NO | varchar | 80 | 240 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(80) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_TYPE_VERSION | 5 | NO | varchar | 20 | 60 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(20) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_LIBRARY | 6 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | ||||
def | information_schema | ALL_PLUGINS | PLUGIN_LIBRARY_VERSION | 7 | NULL | YES | varchar | 20 | 60 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(20) | select | ||||
def | information_schema | ALL_PLUGINS | PLUGIN_AUTHOR | 8 | NULL | YES | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | ||||
def | information_schema | ALL_PLUGINS | PLUGIN_DESCRIPTION | 9 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | ||||
def | information_schema | ALL_PLUGINS | PLUGIN_LICENSE | 10 | NO | varchar | 80 | 240 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(80) | select | |||||
def | information_schema | ALL_PLUGINS | LOAD_OPTION | 11 | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_MATURITY | 12 | NO | varchar | 12 | 36 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(12) | select | |||||
def | information_schema | ALL_PLUGINS | PLUGIN_AUTH_VERSION | 13 | NULL | YES | varchar | 80 | 240 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(80) | select | ||||
def | information_schema | APPLICABLE_ROLES | GRANTEE | 1 | NO | varchar | 190 | 570 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(190) | select | |||||
def | information_schema | APPLICABLE_ROLES | ROLE_NAME | 2 | NO | varchar | 128 | 384 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(128) | select | |||||
def | information_schema | APPLICABLE_ROLES | IS_GRANTABLE | 3 | NO | varchar | 3 | 9 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(3) | select | |||||
def | information_schema | APPLICABLE_ROLES | IS_DEFAULT | 4 | NULL | YES | varchar | 3 | 9 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(3) | select | ||||
def | mysql | arcnlv | data | 1 | NULL | YES | longblob | 4294967295 | 4294967295 | NULL | NULL | NULL | NULL | NULL | longblob | select,insert,update,references | ||||
def | mysql | bxlyey | data | 1 | NULL | YES | longblob | 4294967295 | 4294967295 | NULL | NULL | NULL | NULL | NULL | longblob | select,insert,update,references | ||||
def | information_schema | CHANGED_PAGE_BITMAPS | dummy | 1 | 0 | NO | bigint | NULL | NULL | 20 | 0 | NULL | NULL | NULL | bigint(21) unsigned | select | ||||
def | information_schema | CHARACTER_SETS | CHARACTER_SET_NAME | 1 | NO | varchar | 32 | 96 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(32) | select |
过滤行: |