title: How to import file into sqlite?
body: <p>On a Mac, I have a txt file with two columns, one being an autoincrement in an sqlite table:</p>
  
  <pre><code>, "mytext1"
  , "mytext2"
  , "mytext3"
  </code></pre>
  
  <p>When I try to import this file, I get a datatype mismatch error:</p>
  
  <pre><code>.separator ","
  .import mytextfile.txt mytable
  </code></pre>
  
  <p>How should the txt file be structured so that it uses the autoincrement?</p>
  
  <p>Also, how do I enter in text that will have line breaks?  For example:</p>
  
  <pre><code>"this is a description of the code below.
  The text might have some line breaks and indents.  Here's
  the related code sample:
  
  foreach (int i = 0; i &lt; 5; i++){
  
    //do some stuff here
  
  }
  
  this is a little more follow up text."
  </code></pre>
  
  <p>I need the above inserted into one row.  Is there anything special I need to do to the formatting?  </p>
  
  <p>For one particular table, I want each of my rows as a file and import them that way.  I'm guessing it is a matter of creating some sort of batch file that runs multiple imports.</p>
  
  <p><strong>Edit</strong></p>
  
  <p>That's exactly the syntax I posted, minus a tab since I'm using a comma. The missing line break in my post didn't make it as apparent. Anyways, that gives the mismatch error.</p>