title: How best to import multiple text files into SQLite FTS virtual table?
body: <p>I have multiple text files that I would like to import into a virtual FTS table in SQLite. The documentation <a href="https://www.sqlite.org/fts3.html#section_1" rel="nofollow">here</a> mentions inserting ~500,000 files from the Enron email dataset into a single table.</p>
  
  <p>I do not understand how this was done.</p>
  
  <p>Oreilly <a href="http://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/" rel="nofollow">here</a> says just use INSERT, UPDATE, DELETE, but it is not clear to me how to get content from multiple external files this way.</p>
  
  <p>Is an external script that calls SQLite from the command line with .insert the best way?</p>
  
  <p>If so, how do I prevent arbitrary text in the files from being interpreted as a new column??</p>
  
  <p>Many thanks in advance for your help!</p>