-
.width num1 num2
-
Set column widths for
column
mode.
For example,
sqlite> .width 6 6
sqlite> select * from comments;
36 Hate i
37 Very n
-
.header(s) ON|OFF
-
Turn display of headers on or off.
For example,
sqlite> .headers ON
sqlite> select * from comments;
_id commenent
------------ ------------
36 Hate it
37 Very nice
-
‘;’ or ‘/’
-
Executes the SQL command.
For example,
sqlite> select * from comments
...> ;
36|Hate it
37|Very nice
-
.show
-
Show the current values for various settings.
For example,
sqlite> .show
echo: off
explain: off
headers: off
...
-
.exit or .quit
-
Exit this program.