Warning: count(): Parameter must be an array or an object that implements Countable in D:\www\www540\mysqldumper\inc\functions_sql.php on line 21
SQL-Browser
Warning: count(): Parameter must be an array or an object that implements Countable in D:\www\www540\mysqldumper\inc\functions_sql.php on line 66

[Tools]  Database: `information_schema`  Table: `TABLES`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Data View

new record    Edit table structure

Table `information_schema`.`S`
records 1 - 30 from totally 59    <<    <    >    >>

View: compact   The Query contains 21 Columns
 # 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
  edit delete1. 
def
information_schema
CHARACTER_SETS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
384
0
262957056
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=699050
  edit delete2. 
def
information_schema
COLLATIONS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
231
0
267278319
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=1162058
  edit delete3. 
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
SYSTEM VIEW
MEMORY
10
Fixed
NULL
195
0
261724515
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=1376592
  edit delete4. 
def
information_schema
COLUMNS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=44716
  edit delete5. 
def
information_schema
COLUMN_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2565
0
268119450
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=104653
  edit delete6. 
def
information_schema
ENGINES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
490
0
265188000
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=547827
  edit delete7. 
def
information_schema
EVENTS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=9910
  edit delete8. 
def
information_schema
FILES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2659
0
267931476
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=100953
  edit delete9. 
def
information_schema
GLOBAL_STATUS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
268106720
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=82140
  edit delete10. 
def
information_schema
GLOBAL_VARIABLES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
268106720
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=82140
  edit delete11. 
def
information_schema
KEY_COLUMN_USAGE
SYSTEM VIEW
MEMORY
10
Fixed
NULL
4637
0
268259724
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=57889
  edit delete12. 
def
information_schema
OPTIMIZER_TRACE
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=9256395
  edit delete13. 
def
information_schema
PARAMETERS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=96351
  edit delete14. 
def
information_schema
PARTITIONS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=89538
  edit delete15. 
def
information_schema
PLUGINS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=181252
  edit delete16. 
def
information_schema
PROCESSLIST
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=382386
  edit delete17. 
def
information_schema
PROFILING
SYSTEM VIEW
MEMORY
10
Fixed
NULL
308
0
264993960
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=871543
  edit delete18. 
def
information_schema
REFERENTIAL_CONSTRAINTS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
4814
0
268322732
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=55761
  edit delete19. 
def
information_schema
ROUTINES
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=9335
  edit delete20. 
def
information_schema
SCHEMATA
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3464
0
267815696
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=77492
  edit delete21. 
def
information_schema
SCHEMA_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2179
0
267820890
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=123192
  edit delete22. 
def
information_schema
SESSION_STATUS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
268106720
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=82140
  edit delete23. 
def
information_schema
SESSION_VARIABLES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
3268
0
268106720
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=82140
  edit delete24. 
def
information_schema
STATISTICS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
5753
0
268107059
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=46660
  edit delete25. 
def
information_schema
TABLES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
9441
0
268228251
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=28432
  edit delete26. 
def
information_schema
TABLESPACES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
6951
0
268392012
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=38618
  edit delete27. 
def
information_schema
TABLE_CONSTRAINTS
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2504
0
267579944
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=107202
  edit delete28. 
def
information_schema
TABLE_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
2372
0
267981444
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=113168
  edit delete29. 
def
information_schema
TRIGGERS
SYSTEM VIEW
MyISAM
10
Dynamic
NULL
0
0
281474976710655
1024
0
NULL
2020-12-31 20:35:29
2020-12-31 20:35:29
NULL
utf8_general_ci
NULL
max_rows=9112
  edit delete30. 
def
information_schema
USER_PRIVILEGES
SYSTEM VIEW
MEMORY
10
Fixed
NULL
1986
0
267625416
0
0
NULL
2020-12-31 20:35:29
NULL
NULL
utf8_general_ci
NULL
max_rows=135163

records 1 - 30 from totally 59    <<    <    >    >>