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
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
GEOMETRY_COLUMNS
SPATIAL_REF_SYS
CLIENT_STATISTICS
INDEX_STATISTICS
INNODB_SYS_DATAFILES
USER_STATISTICS
INNODB_SYS_TABLESTATS
INNODB_LOCKS
INNODB_MUTEXES
INNODB_CMPMEM
INNODB_CMP_PER_INDEX
INNODB_CMP
INNODB_FT_DELETED
INNODB_CMP_RESET
INNODB_LOCK_WAITS
TABLE_STATISTICS
INNODB_TABLESPACES_ENCRYPTION
INNODB_BUFFER_PAGE_LRU
INNODB_SYS_FIELDS
INNODB_CMPMEM_RESET
INNODB_SYS_COLUMNS
INNODB_FT_INDEX_TABLE
INNODB_CMP_PER_INDEX_RESET
user_variables
INNODB_FT_INDEX_CACHE
INNODB_SYS_FOREIGN_COLS
INNODB_FT_BEING_DELETED
INNODB_BUFFER_POOL_STATS
INNODB_TRX
INNODB_SYS_FOREIGN
INNODB_SYS_TABLES
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_CONFIG
INNODB_BUFFER_PAGE
INNODB_SYS_TABLESPACES
INNODB_METRICS
INNODB_SYS_INDEXES
INNODB_SYS_VIRTUAL
INNODB_TABLESPACES_SCRUBBING
INNODB_SYS_SEMAPHORE_WAITS
Die Suche nach "
" in der Tabelle "
STATISTICS
" lieferte folgende Treffer:
Blättern: vor=ALT+V, zurück=ALT+C
#
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
NON_UNIQUE
INDEX_SCHEMA
INDEX_NAME
SEQ_IN_INDEX
COLUMN_NAME
COLLATION
CARDINALITY
SUB_PART
PACKED
NULLABLE
INDEX_TYPE
COMMENT
INDEX_COMMENT
1.
def
mysql
host
0
mysql
PRIMARY
1
Host
A
BTREE
2.
def
mysql
host
0
mysql
PRIMARY
2
Db
A
0
BTREE
3.
def
mysql
gtid_slave_pos
0
mysql
PRIMARY
1
sub_id
A
0
BTREE
4.
def
mysql
innodb_index_stats
0
mysql
PRIMARY
1
table_name
A
17
BTREE
5.
def
mysql
innodb_index_stats
0
mysql
PRIMARY
2
index_name
A
34
BTREE
6.
def
mysql
innodb_index_stats
0
mysql
PRIMARY
3
stat_name
A
34
BTREE
7.
def
mysql
innodb_table_stats
0
mysql
PRIMARY
1
table_name
A
7
BTREE
8.
def
mysql
help_keyword
0
mysql
name
1
name
A
105
BTREE
9.
def
mysql
tables_priv
0
mysql
PRIMARY
1
Host
A
BTREE
10.
def
mysql
tables_priv
0
mysql
PRIMARY
2
Db
A
BTREE
11.
def
mysql
tables_priv
0
mysql
PRIMARY
3
User
A
BTREE
12.
def
mysql
tables_priv
0
mysql
PRIMARY
4
Table_name
A
0
BTREE
13.
def
mysql
tables_priv
1
mysql
Grantor
1
Grantor
A
BTREE
14.
def
mysql
db
0
mysql
PRIMARY
1
Host
A
BTREE
15.
def
mysql
db
0
mysql
PRIMARY
2
Db
A
BTREE
16.
def
mysql
db
0
mysql
PRIMARY
3
User
A
0
BTREE
17.
def
mysql
db
1
mysql
User
1
User
A
BTREE
18.
def
mysql
time_zone_name
0
mysql
PRIMARY
1
Name
A
0
BTREE
19.
def
mysql
index_stats
0
mysql
PRIMARY
1
db_name
A
BTREE
20.
def
mysql
index_stats
0
mysql
PRIMARY
2
table_name
A
BTREE