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
- PowerShell88 commands
- Kubernetes53 commands
- macOS52 commands
- Git52 commands
- Cloud48 commands
- Cisco IOS48 commands
The same reference, with no signal at all
Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).
Get it free on the App Store