Command Line Shell for SQLite (Cont.)
.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.



      Asking my husband to help out around the house is like    
      banging my head against the wall (annoying).