DBMS

DBMS Command

• SQL utils commands (MySQL, MSSQL)

SQLite

# shell
sqlite3 db.db
sqlite3 db.sqlite
sqlitebrowser db.db

-- SQLite
.databases           -- list databases
.tables              -- list tables
.schema <table>      -- show structure of table
.dump <table>        -- dump content of table

.headers on          -- show names of columns
.mode <column>       -- columns formate
.mode <csv>          -- export to CSV
.output fichier.txt  -- redirect output to file
.exit                -- exit SQLite

PRAGMA table_info(table_name); -- Show table information

Neo4j

• Neo4j cheatsheet

Redis

• Redis cheatsheet