fachinformatiker-wiki

it's easy when it's here

User Tools

Site Tools

Trace:
datenbanken:mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
datenbanken:mysql [2023/03/31 21:34] – admindatenbanken:mysql [2025/03/03 15:04] (current) – [Befehle] gsys
Line 21: Line 21:
 SHOW FIELDS FROM tabelle;                       # Struktur einer Tabelle anzeigen SHOW FIELDS FROM tabelle;                       # Struktur einer Tabelle anzeigen
 DESCRIBE user;                                  #    "       "      "       "   DESCRIBE user;                                  #    "       "      "       "  
 +show grants;                                    # Berechtigungen für angemeldeten user anzeigen
 +show grants for 'user'@'10.1.2.3';              # Berechtigungen für user mit ip anzeigen
 </code> </code>
  
Line 45: Line 47:
 ALTER TABLE `tabelle`  AUTO_INCREMENT = 1; ALTER TABLE `tabelle`  AUTO_INCREMENT = 1;
 </code> </code>
 +
 +** Get Tables Sizes from all DBs **
 +<code mysql>
 +SELECT
 +  TABLE_NAME AS `Table`,
 +  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
 +FROM
 +  information_schema.TABLES
 +WHERE
 +  TABLE_SCHEMA = "$DB_NAME"
 +ORDER BY
 +  (DATA_LENGTH + INDEX_LENGTH)
 +DESC;
 +</code>
 +
datenbanken/mysql.1680291256.txt.gz · Last modified: 2024/02/17 19:03 (external edit)