MySQL-ERROR |
MySQL meldet: Access denied for user 'filmtheater'@'localhost' to database 'information_schema' |
Fehler bei der Anfrage: DELETE FROM `PARTITIONS` WHERE `TABLE_CATALOG`="def" AND `TABLE_SCHEMA`="information_schema" AND `TABLE_NAME`="PLUGINS" AND `PARTITION_NAME`="" AND `SUBPARTITION_NAME`="" AND `PARTITION_ORDINAL_POSITION`="" AND `SUBPARTITION_ORDINAL_POSITION`="" AND `PARTITION_METHOD`="" AND `SUBPARTITION_METHOD`="" AND `PARTITION_EXPRESSION`="" AND `SUBPARTITION_EXPRESSION`="" AND `PARTITION_DESCRIPTION`="" AND `TABLE_ROWS`="0" AND `AVG_ROW_LENGTH`="0" AND `DATA_LENGTH`="8192" AND `MAX_DATA_LENGTH`="4503599627288576" AND `INDEX_LENGTH`="8192" AND `DATA_FREE`="0" AND `CREATE_TIME`="2024-05-19 15:32:59" AND `UPDATE_TIME`="2024-05-19 15:32:59" AND `CHECK_TIME`="" AND `CHECKSUM`="" AND `PARTITION_COMMENT`="" AND `NODEGROUP`="" AND `TABLESPACE_NAME`="" LIMIT 1 |
Datensatz wurde gelöscht
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`PARTITIONS`
Datensätze 1 - 30 von insgesamt 82 << < > >>
Ansicht: kompakt Die Abfrage enthält 25 Spalten | ||||||||||||||||||||||||||
# | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION [BB] | SUBPARTITION_EXPRESSION [BB] | PARTITION_DESCRIPTION [BB] | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1. | def | information_schema | ALL_PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
2. | def | information_schema | APPLICABLE_ROLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 980 | 0 | 33418000 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
3. | def | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 384 | 0 | 32869632 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
4. | def | information_schema | CHECK_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
5. | def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 231 | 0 | 33409761 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
6. | def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 32715540 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
7. | def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
8. | def | information_schema | COLUMN_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2893 | 0 | 33518298 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
9. | def | information_schema | ENABLED_ROLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 388 | 0 | 33212024 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
10. | def | information_schema | ENGINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 732 | 0 | 33371880 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
11. | def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
12. | def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4004 | 0 | 33517484 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
13. | def | information_schema | GLOBAL_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6340 | 0 | 33532260 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
14. | def | information_schema | GLOBAL_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6340 | 0 | 33532260 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
15. | def | information_schema | KEYWORDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 32715540 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
16. | def | information_schema | KEY_CACHES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 660 | 0 | 33351780 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
17. | def | information_schema | KEY_COLUMN_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4638 | 0 | 33537378 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
18. | def | information_schema | OPTIMIZER_TRACE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
19. | def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
20. | def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
21. | def | information_schema | PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
22. | def | information_schema | PROCESSLIST | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
23. | def | information_schema | PROFILING | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 309 | 0 | 33231714 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
24. | def | information_schema | REFERENTIAL_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4815 | 0 | 33546105 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
25. | def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-06-10 13:13:33 | 2024-06-10 13:13:33 | NULL | NULL | NULL | |||
26. | def | information_schema | SCHEMATA | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6539 | 0 | 33525453 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
27. | def | information_schema | SCHEMA_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2507 | 0 | 33485999 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
28. | def | information_schema | SESSION_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6340 | 0 | 33532260 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
29. | def | information_schema | SESSION_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 6340 | 0 | 33532260 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL | |||
30. | def | information_schema | STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 5754 | 0 | 33517050 | 0 | 0 | 2024-06-10 13:13:33 | NULL | NULL | NULL | NULL |
Datensätze 1 - 30 von insgesamt 82 << < > >>