title: Import CSV file into Sqlite3 Database in command-line or via Batch File
body: <p>I would like to inquire on whether is there anyway to import a csv file that contains output of my select statements in SQLite3 into a new database?
  Following are the codes i have done thus far:</p>
  
  <pre><code>sqlite3.exe -csv logsql.sqlite "SELECT local_port AS port, COUNT(local_port) AS hitcount FROM connections  WHERE connection_type = 'accept' GROUP BY local_port ORDER BY hitcount DESC;" &gt; output.csv
  sqlite3.exe -csv test.sqlite "CREATE TABLE test (name varchar(255) not null, blah varchar(255) not null);" .import ./output.csv test
  </code></pre>
  
  <p>as you can see my first code was to dump out the queries made.</p>
  
  <p>the second line of code i'm attempting to make a new database and attemptign to import the csv file into the table "test"</p>
  
  <p>thanks for any help made in advance! :D</p>