https://wiki.primat.ch/index.php?action=history&feed=atom&title=MySQL_in_AnwendungMySQL in Anwendung - Versionsgeschichte2026-05-19T17:59:03ZVersionsgeschichte dieser Seite in PrimatenwikiMediaWiki 1.43.0https://wiki.primat.ch/index.php?title=MySQL_in_Anwendung&diff=77&oldid=prevRbritt: Die Seite wurde neu angelegt: «== Tabellengrösse in MB ausgeben == <source lang="sql"> SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC; </source> == Alle Tabellen ausgeben == <source lang="sql"> SELECT table_schema as `Database`, table_name AS `Table` FROM information_schema.TABLES WHERE table_schema not…»2025-01-08T18:21:12Z<p>Die Seite wurde neu angelegt: «== Tabellengrösse in MB ausgeben == <source lang="sql"> SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC; </source> == Alle Tabellen ausgeben == <source lang="sql"> SELECT table_schema as `Database`, table_name AS `Table` FROM information_schema.TABLES WHERE table_schema not…»</p>
<p><b>Neue Seite</b></p><div>== Tabellengrösse in MB ausgeben ==<br />
<source lang="sql"><br />
SELECT <br />
table_schema as `Database`, <br />
table_name AS `Table`, <br />
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` <br />
FROM information_schema.TABLES <br />
ORDER BY (data_length + index_length) DESC;<br />
</source><br />
<br />
== Alle Tabellen ausgeben ==<br />
<source lang="sql"><br />
SELECT <br />
table_schema as `Database`, <br />
table_name AS `Table`<br />
FROM information_schema.TABLES <br />
WHERE table_schema not like "perform%" AND table_schema not like "inform%" AND table_schema not like "sys" AND table_schema not like "mysql"<br />
ORDER BY table_schema, table_name;<br />
</source></div>Rbritt