Appendix B. Command Reference for the sqlite Tool
This appendix lists the commands that can be used within the sqlite monitor program.
Dot Commands
The dot commands for sqlite can be used to change the output format, fetch information about the database, and modify some settings. In this appendix, each dot command is shown first followed by an explanation.
Obtaining a List of Dot Commands
.help
Displays the full list of dot commands for the installed sqlite with brief descriptions.
Changing the Output Format
.mode list
The default output mode. Displays one line per record, with each column separated by a specific character or string. The default separator is the pipe character (|).
.separator string
Changes the separator for list mode output to
Get SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
