[Tools]
Datenbank:
`fhem`
Tabelle: `TABLES`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `fhem`.`S`
Datensätze 1 - 30 von insgesamt 167 << < > >>
| Ansicht: kompakt Die Abfrage enthält 23 Spalten | ||||||||||||||||||||||||
| # |  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 | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=9441 | 137438945280 | Y | |
|
| 2. | def | information_schema | APPLICABLE_ROLES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 979 | 0 | 16759501 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=17137 | 0 | Y | |
|
| 3. | def | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 384 | 0 | 16604160 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=43690 | 0 | Y | |
|
| 4. | def | information_schema | CHECK_CONSTRAINTS | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=7880 | 137438945280 | Y | |
|
| 5. | def | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 231 | 0 | 16704765 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=72628 | 0 | Y | |
|
| 6. | def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 195 | 0 | 16691610 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=86037 | 0 | Y | |
|
| 7. | def | information_schema | COLUMNS | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=2712 | 137438945280 | Y | |
|
| 8. | def | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 2893 | 0 | 16759149 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=5799 | 0 | Y | |
|
| 9. | def | information_schema | ENABLED_ROLES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 387 | 0 | 16733880 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=43351 | 0 | Y | |
|
| 10. | def | information_schema | ENGINES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 731 | 0 | 16753789 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=22951 | 0 | Y | |
|
| 11. | def | information_schema | EVENTS | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=611 | 137438945280 | Y | |
|
| 12. | def | information_schema | FILES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 4022 | 0 | 16767718 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=4171 | 0 | Y | |
|
| 13. | def | information_schema | GLOBAL_STATUS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 6340 | 0 | 16762960 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=2646 | 0 | Y | |
|
| 14. | def | information_schema | GLOBAL_VARIABLES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 6340 | 0 | 16762960 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=2646 | 0 | Y | |
|
| 15. | def | information_schema | KEYWORDS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 194 | 0 | 16606012 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=86480 | 0 | Y | |
|
| 16. | def | information_schema | KEY_CACHES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 659 | 0 | 16751780 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=25458 | 0 | Y | |
|
| 17. | def | information_schema | KEY_COLUMN_USAGE | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 4637 | 0 | 16762755 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=3618 | 0 | Y | |
|
| 18. | def | information_schema | PARAMETERS | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=6030 | 137438945280 | Y | |
|
| 19. | def | information_schema | PARTITIONS | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=5579 | 137438945280 | Y | |
|
| 20. | def | information_schema | PLUGINS | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=9441 | 137438945280 | Y | |
|
| 21. | def | information_schema | PROCESSLIST | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=15224 | 137438945280 | Y | |
|
| 22. | def | information_schema | PROFILING | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 308 | 0 | 16562084 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=54471 | 0 | Y | |
|
| 23. | def | information_schema | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 4814 | 0 | 16767162 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=3485 | 0 | Y | |
|
| 24. | def | information_schema | ROUTINES | SYSTEM VIEW | Aria | 11 | Page | NULL | 0 | 8192 | 4294967295 | 8192 | 0 | NULL | 2024-05-16 02:40:40 | 2024-05-16 02:40:40 | NULL | utf8_general_ci | NULL | max_rows=576 | 137438945280 | Y | |
|
| 25. | def | information_schema | SCHEMATA | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 3464 | 0 | 16755368 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=4843 | 0 | Y | |
|
| 26. | def | information_schema | SCHEMA_PRIVILEGES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 2507 | 0 | 16769323 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=6692 | 0 | Y | |
|
| 27. | def | information_schema | SESSION_STATUS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 6340 | 0 | 16762960 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=2646 | 0 | Y | |
|
| 28. | def | information_schema | SESSION_VARIABLES | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 6340 | 0 | 16762960 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=2646 | 0 | Y | |
|
| 29. | def | information_schema | STATISTICS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 5753 | 0 | 16764242 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=2916 | 0 | Y | |
|
| 30. | def | information_schema | SQL_FUNCTIONS | SYSTEM VIEW | MEMORY | 11 | Fixed | NULL | 194 | 0 | 16606012 | 0 | 0 | NULL | 2024-05-16 02:40:40 | NULL | NULL | utf8_general_ci | NULL | max_rows=86480 | 0 | Y | |
Datensätze 1 - 30 von insgesamt 167 << < > >>