SQL-Browser
Suche
Suchbegriff(e):
Suchoptionen
eine Spalte muss alle Suchbegriffe enthalten (UND-Suche)
eine Spalte muss mindestens einen Suchbegriff enthalten (ODER-Suche)
ein Datensatz muss alle Suchbegriffe enthalten, diese können aber in beliebigen Spalten sein (Rechenintensiv!)
Suche in Tabelle:
ALL_PLUGINS
APPLICABLE_ROLES
CHARACTER_SETS
CHECK_CONSTRAINTS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
ENABLED_ROLES
ENGINES
EVENTS
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
KEYWORDS
KEY_CACHES
KEY_COLUMN_USAGE
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
SESSION_STATUS
SESSION_VARIABLES
STATISTICS
SQL_FUNCTIONS
SYSTEM_VARIABLES
TABLES
TABLESPACES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
CLIENT_STATISTICS
INDEX_STATISTICS
INNODB_SYS_DATAFILES
GEOMETRY_COLUMNS
INNODB_SYS_TABLESTATS
SPATIAL_REF_SYS
INNODB_BUFFER_PAGE
INNODB_TRX
INNODB_CMP_PER_INDEX
INNODB_METRICS
INNODB_LOCK_WAITS
INNODB_CMP
THREAD_POOL_WAITS
INNODB_CMP_RESET
THREAD_POOL_QUEUES
TABLE_STATISTICS
INNODB_SYS_FIELDS
INNODB_BUFFER_PAGE_LRU
INNODB_LOCKS
INNODB_FT_INDEX_TABLE
INNODB_CMPMEM
THREAD_POOL_GROUPS
INNODB_CMP_PER_INDEX_RESET
INNODB_SYS_FOREIGN_COLS
INNODB_FT_INDEX_CACHE
INNODB_BUFFER_POOL_STATS
INNODB_FT_BEING_DELETED
INNODB_SYS_FOREIGN
INNODB_CMPMEM_RESET
INNODB_FT_DEFAULT_STOPWORD
INNODB_SYS_TABLES
INNODB_SYS_COLUMNS
INNODB_FT_CONFIG
USER_STATISTICS
INNODB_SYS_TABLESPACES
INNODB_SYS_VIRTUAL
INNODB_SYS_INDEXES
INNODB_SYS_SEMAPHORE_WAITS
INNODB_MUTEXES
user_variables
INNODB_TABLESPACES_ENCRYPTION
INNODB_FT_DELETED
THREAD_POOL_STATS
Die Suche nach "
" in der Tabelle "
COLUMNS
" lieferte folgende Treffer:
Blättern: vor=ALT+V, zurück=ALT+C
#
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
IS_GENERATED
GENERATION_EXPRESSION
1.
def
information_schema
ALL_PLUGINS
PLUGIN_NAME
1
NO
varchar
64
192
utf8
utf8_general_ci
varchar(64)
select
NEVER
2.
def
information_schema
ALL_PLUGINS
PLUGIN_VERSION
2
NO
varchar
20
60
utf8
utf8_general_ci
varchar(20)
select
NEVER
3.
def
information_schema
ALL_PLUGINS
PLUGIN_STATUS
3
NO
varchar
16
48
utf8
utf8_general_ci
varchar(16)
select
NEVER
4.
def
information_schema
ALL_PLUGINS
PLUGIN_TYPE
4
NO
varchar
80
240
utf8
utf8_general_ci
varchar(80)
select
NEVER
5.
def
information_schema
ALL_PLUGINS
PLUGIN_TYPE_VERSION
5
NO
varchar
20
60
utf8
utf8_general_ci
varchar(20)
select
NEVER
6.
def
information_schema
ALL_PLUGINS
PLUGIN_LIBRARY
6
YES
varchar
64
192
utf8
utf8_general_ci
varchar(64)
select
NEVER
7.
def
information_schema
ALL_PLUGINS
PLUGIN_LIBRARY_VERSION
7
YES
varchar
20
60
utf8
utf8_general_ci
varchar(20)
select
NEVER
8.
def
information_schema
ALL_PLUGINS
PLUGIN_AUTHOR
8
YES
varchar
64
192
utf8
utf8_general_ci
varchar(64)
select
NEVER
9.
def
information_schema
ALL_PLUGINS
PLUGIN_DESCRIPTION
9
YES
longtext
4294967295
4294967295
utf8
utf8_general_ci
longtext
select
NEVER
10.
def
information_schema
ALL_PLUGINS
PLUGIN_LICENSE
10
NO
varchar
80
240
utf8
utf8_general_ci
varchar(80)
select
NEVER
11.
def
information_schema
ALL_PLUGINS
LOAD_OPTION
11
NO
varchar
64
192
utf8
utf8_general_ci
varchar(64)
select
NEVER
12.
def
information_schema
ALL_PLUGINS
PLUGIN_MATURITY
12
NO
varchar
12
36
utf8
utf8_general_ci
varchar(12)
select
NEVER
13.
def
information_schema
ALL_PLUGINS
PLUGIN_AUTH_VERSION
13
YES
varchar
80
240
utf8
utf8_general_ci
varchar(80)
select
NEVER
14.
def
information_schema
APPLICABLE_ROLES
GRANTEE
1
NO
varchar
190
570
utf8
utf8_general_ci
varchar(190)
select
NEVER
15.
def
information_schema
APPLICABLE_ROLES
ROLE_NAME
2
NO
varchar
128
384
utf8
utf8_general_ci
varchar(128)
select
NEVER
16.
def
information_schema
APPLICABLE_ROLES
IS_GRANTABLE
3
NO
varchar
3
9
utf8
utf8_general_ci
varchar(3)
select
NEVER
17.
def
information_schema
APPLICABLE_ROLES
IS_DEFAULT
4
YES
varchar
3
9
utf8
utf8_general_ci
varchar(3)
select
NEVER
18.
def
information_schema
CHARACTER_SETS
CHARACTER_SET_NAME
1
NO
varchar
32
96
utf8
utf8_general_ci
varchar(32)
select
NEVER
19.
def
information_schema
CHARACTER_SETS
DEFAULT_COLLATE_NAME
2
NO
varchar
32
96
utf8
utf8_general_ci
varchar(32)
select
NEVER
20.
def
information_schema
CHARACTER_SETS
DESCRIPTION
3
NO
varchar
60
180
utf8
utf8_general_ci
varchar(60)
select
NEVER