title: Import csv with pycharm database tool
body: <p><a href="https://i.stack.imgur.com/jw4Dg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jw4Dg.png" alt="enter image description here"></a>I'm working with pycharm on windows and want to import a csv file into a preexisting sqllite table. I've tried variations of:</p>
  
  <pre><code>.import test.csv foo
  </code></pre>
  
  <p>based on <a href="https://stackoverflow.com/questions/14947916/import-csv-to-sqlite">Import CSV to SQLite</a> , but this is not recognized. Also I don't see an answer in <a href="https://www.jetbrains.com/help/pycharm/2016.1/database-tool-window.html" rel="nofollow noreferrer">https://www.jetbrains.com/help/pycharm/2016.1/database-tool-window.html</a></p>
  
  <p>Can this be done?</p>