Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Command Reference

Shell commands available in the cqlsh-rs interactive prompt. These are distinct from CQL statements — they control the shell itself.

Quick reference

CommandDescription
CAPTURECapture output to a file
CLEARClear the terminal screen
CONSISTENCYGet/set consistency level
COPY TOExport table data to CSV
COPY FROMImport CSV data into a table
DEBUGToggle debug mode
DESCRIBESchema introspection
EXIT / QUITExit the shell
EXPANDToggle expanded (vertical) output
HELPShow help
LOGINRe-authenticate with new credentials
PAGINGConfigure automatic paging
SERIAL CONSISTENCYGet/set serial consistency level
SHOWShow version, host, or session trace info
SOURCEExecute CQL from a file
TRACINGToggle request tracing
UNICODEShow Unicode/encoding info
USESwitch keyspace

CQL statements

All standard CQL statements (SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, etc.) are sent directly to the database for execution. Terminate statements with a semicolon (;).