title: sqlite error importing csv through command line
body: <pre><code>$ sqlite3 test.sql
  SQLite version 3.6.12
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite&gt; create table test (id integer, author_id integer, title varchar(128), name text);
  sqlite&gt; .separator ";"
  sqlite&gt; .import sqlite.csv test
  sqlite.csv line 3: expected 4 columns of data but found 1
  sqlite&gt; .separator ';'
  sqlite&gt; .import sqlite.csv test
  sqlite.csv line 3: expected 4 columns of data but found 1
  sqlite&gt; 
  </code></pre>
  
  <p>I am trying to import the csv table with ; as a seperator to sqlite but it wasn't able to find 4 columns. I export from sql to csv with checked 'Put fields names in the first row'. Could I be missing something here?</p>
  
  <p>first 5 lines of csv </p>
  
  <pre><code>id;"author_id";"title";"poem"       
  1;"92";"A Letter From Italy";"Salve magna parens frugum Saturnia tellus     
  Magna virm! tibi res antiqu laudis et artis     
  Aggredior    sanctos ausus recludere fontes.    
  Virg. Geor. 2.  
  </code></pre>