SQL commands
database
- CREATE TABLECreate tables
- SELECT ... JOINJoin tables
- BEGIN / COMMIT / ROLLBACKTransactions
- ALTER TABLEAlter table structure
- GROUP BYGroup and aggregate
- GRANTGrant privileges
- ORDER BY / LIMITSorting and paging
- リストア(mysql/psql)Restore from a dump
- CREATE USERCreate database users
- LIKE / ワイルドカードPattern matching
- psqlメタコマンドpsql meta-commands
- SHOW STATUS / VARIABLESServer status & variables
- DROP TABLEDrop tables
- REVOKERevoke privileges
- SHOW GRANTSShow grants
- SHOW INDEXInspect indexes
- SHOW REPLICA STATUSReplication status
- TRUNCATE TABLEEmpty a table fast
- pg_dump / pg_restorePostgreSQL dump/restore
- スロークエリログSlow query logging
- 文字コード確認・変更Database character sets
- ALTER USERChange passwords/expiry
- ANALYZE TABLERefresh optimizer stats
- VACUUMVacuum (PostgreSQL)
- pg_stat_activityPostgres sessions
- 外部キー制約Foreign keys
- CREATE VIEWCreate views
- WITH(CTE)Common table expressions
- バイナリログBinary logs
- OPTIMIZE TABLERebuild/defragment tables
- mysqladminmysqladmin one-liners
SQL
- SELECTRead data
- Connect (psql/mysql/sqlcmd)Connect to a DB
- SHOW DATABASESList databases
- Show running queriesShow running queries
- SHOW TABLESList tables
- DESCRIBEDescribe a table
- Dump / backupBack up a DB
- UPDATEUpdate rows
- EXPLAINQuery plan
- INSERTInsert rows
- DELETEDelete rows
- CREATE INDEXCreate an index
- Kill query / sessionKill a query/session
Other platforms
- Linux178 commands
- Windows107 commands
- PowerShell89 commands
- Kubernetes53 commands
- macOS52 commands
- Git52 commands
- Cloud48 commands
- Cisco IOS48 commands
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store