WereDoku

User Tools

Site Tools

Trace: • linux_skodi
databaze

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
databaze [2017/09/16 07:57] – wwdatabaze [2026/06/20 15:35] (current) – external edit 127.0.0.1
Line 18: Line 18:
 <code postgresql>\l</code> <code postgresql>\l</code>
      
-Vvýběr databáze+Výběr databáze
 <code postgresql>\connect dbname</code> <code postgresql>\connect dbname</code>
      
Line 26: Line 26:
 Výpis uživatelů Výpis uživatelů
 <code postgresql>\du</code> <code postgresql>\du</code>
 +
 +==== Migrace mezi verzemi ====
 +https://www.kostolansky.sk/posts/upgrading-to-postgresql-12/
 +
 +----
  
 ===== MySQL / MariaDB ===== ===== MySQL / MariaDB =====
Line 34: Line 39:
 GRANT ALL ON dbname.* TO username@localhost IDENTIFIED BY 'somepass'; GRANT ALL ON dbname.* TO username@localhost IDENTIFIED BY 'somepass';
 </code> </code>
 +
 +Seznam databází
 +<code mysql>SHOW DATABASES;</code>
 +
 +----
 +
 +===== SQLite =====
 +
 +==== Výpis tabulek ====
 +
 +<code>.tables</code>
databaze.1505548662.txt.gz · Last modified: (external edit)