SQL-Browser
Search
Searchword(s):
Search options
a column must contain all search words (AND-search)
a column must have one of the search words (OR-search)
a row must contain all of the search words but they can be in any column (could take some time)
Search in table:
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
The search for "
" in table "
TABLES
" brings the following results:
Browse: forward=ALT+V, backwards=ALT+C
#
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
ENGINE
VERSION
ROW_FORMAT
TABLE_ROWS
AVG_ROW_LENGTH
DATA_LENGTH
MAX_DATA_LENGTH
INDEX_LENGTH
DATA_FREE
AUTO_INCREMENT
CREATE_TIME
UPDATE_TIME
CHECK_TIME
TABLE_COLLATION
CHECKSUM
CREATE_OPTIONS
TABLE_COMMENT
MAX_INDEX_LENGTH
TEMPORARY
1.
def
information_schema
ALL_PLUGINS
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=10380835156842741 transactional=0
137438945280
Y
2.
def
information_schema
APPLICABLE_ROLES
SYSTEM VIEW
MEMORY
11
Fixed
980
0
33418000
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=34239
0
Y
3.
def
information_schema
CHARACTER_SETS
SYSTEM VIEW
MEMORY
11
Fixed
384
0
32869632
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=87381
0
Y
4.
def
information_schema
CHECK_CONSTRAINTS
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=8587869680497929 transactional=0
137438945280
Y
5.
def
information_schema
COLLATIONS
SYSTEM VIEW
MEMORY
11
Fixed
231
0
33409761
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=145257
0
Y
6.
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
SYSTEM VIEW
MEMORY
11
Fixed
195
0
32715540
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=172074
0
Y
7.
def
information_schema
COLUMNS
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=2982497020809951 transactional=0
137438945280
Y
8.
def
information_schema
COLUMN_PRIVILEGES
SYSTEM VIEW
MEMORY
11
Fixed
2893
0
33518298
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=11598
0
Y
9.
def
information_schema
ENABLED_ROLES
SYSTEM VIEW
MEMORY
11
Fixed
388
0
33212024
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=86480
0
Y
10.
def
information_schema
ENGINES
SYSTEM VIEW
MEMORY
11
Fixed
732
0
33371880
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=45839
0
Y
11.
def
information_schema
EVENTS
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=672649652629432 transactional=0
137438945280
Y
12.
def
information_schema
FILES
SYSTEM VIEW
MEMORY
11
Fixed
4004
0
33517484
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=8380
0
Y
13.
def
information_schema
GLOBAL_STATUS
SYSTEM VIEW
MEMORY
11
Fixed
6340
0
33532260
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=5292
0
Y
14.
def
information_schema
GLOBAL_VARIABLES
SYSTEM VIEW
MEMORY
11
Fixed
6340
0
33532260
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=5292
0
Y
15.
def
information_schema
KEYWORDS
SYSTEM VIEW
MEMORY
11
Fixed
195
0
32715540
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=172074
0
Y
16.
def
information_schema
KEY_CACHES
SYSTEM VIEW
MEMORY
11
Fixed
660
0
33351780
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=50840
0
Y
17.
def
information_schema
KEY_COLUMN_USAGE
SYSTEM VIEW
MEMORY
11
Fixed
4638
0
33537378
0
0
2024-09-22 06:01:39
utf8_general_ci
max_rows=7234
0
Y
18.
def
information_schema
OPTIMIZER_TRACE
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=636094623231363848 transactional=0
137438945280
Y
19.
def
information_schema
PARAMETERS
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=6630749127861089 transactional=0
137438945280
Y
20.
def
information_schema
PARTITIONS
SYSTEM VIEW
Aria
11
Page
0
8192
4503599627288576
8192
0
2024-09-22 06:01:39
2024-09-22 06:01:39
utf8_general_ci
max_rows=6153016702371431 transactional=0
137438945280
Y