title: How to append data from csv file to sqlite?
body: <p>I'm trying to add rows from a CSV file to an existing table. </p>
  
  <p>In Mac Terminal, I start sqlite3:</p>
  
  <p>sqlite> .open database.db</p>
  
  <p>sqlite> .import test.csv table</p>
  
  <p>.
  .
  .</p>
  
  <p>test.csv:43200: expected 22 columns but found 1 - filling the rest with NULL</p>
  
  <p>sqlite></p>
  
  <p>Notice there are 43200 rows in the csv file. The file itself has 22 comma separated columns, but sqlite only thinks there is 1 column.</p>